Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

How join columns from one table to other table

Solved936 views30th January 2024
1
Jaroslaw Burtny [DevOps Advocate]678 26th January 2024 0 Comments

Hi ALL.

Can I join columns from one table from QUERIES to other table?
How to do it ?

Big Thanks for help.

Br.

Jarek

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 30th January 2024

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
2
Randy Ulvenes [SLC] [DevOps Advocate]999 Posted 27th January 2024 1 Comment

Hi Jerek,

Hopefully the following will help you out some more.

Here is an example of joining two tables and using the "Stream FK" parameter to be the parameter field I want to match for my "join" of these two tables.  (Service Table and Ethernet Table)

I started by creating a query that will create a a new table from the Service parameters table.  I chose the same parameters in the above Service Table image.    During the creation of this query and before I do the join, I put the half finished query into a dashboard component table to see if the 1st table (i.e Service Table) is correct. As you create the join of the 2nd table, this dashboard component will update real time which is cool to see if your doing it correctly.

Below is the start of my query to join the two tables.  The 1st table ends right before the "join" operation.  Table 7000 is the Service table.

After I select the Parameters from this table (Bit Rate, Stream FK, CC Errors, and Full Description)  you will choose join and then the type of "join".  Inner, Outer, Left, or Right.

The next step after the inner join is essentially creating the new ethernet table query.  I created a second table from the parameter table 4200 (Ethernet Table).   I selected the parameters I want to use from this table.

You will then be asked to what parameter from each table  to perform the join  (circled in green).  I am using the Stream FK.   I did an "Inner Join" so that I will only display the rows where the Stream FK match in each table.

Here is the results of the joined table.  You may not want to show the Stream FK in this table.  If not you can use the filter to remove them from the component.

Now your can customize the table columns buy dragging which parameters you want to include in a new table.  In my final example, I did not want the Stream FK to be displayed and did not drag these into the table component.

Here is my final result of the joined tables.

I add some conditional colors to the CC ERRORS column

The conditional color range is selected in the Layout Tab as shown below.  Zero is green and anything greator or equal to 1 is red.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 30th January 2024
Jaroslaw Burtny [DevOps Advocate] commented 27th January 2024

Hi Randy.
Big tahnks for help it resolved my problems.
Can you look on my other problem :
https://community.dataminer.services/question/how-to-combine-information-from-two-tables-into-a-dcf-query/
I will be grateful for the help
Br.
Jarek

You are viewing 1 out of 2 answers, click here to view all answers.
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin