Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JonathanKelly
Contributor III
Contributor III

2 Fields in a Table linked to an independent table

I am combining multiple sources through concatenation to create one singular table.

Each source is for different types of works so they are held in independent locations on a database. Each type of work has a company ID associated with each job. However, one of the sources doesn't hold a company ID it holds a UID which is a specific ID that only that type of works use. I want to link both of these ID's to a Company Name table so that I can filter my data by company 

e.g.

3 Source tables:

JonathanKelly_2-1738333646975.png

Concatenated to the below;

JonathanKelly_3-1738333659738.png

I am trying to link the above with the below so that I can filter by company name

JonathanKelly_4-1738333754723.png

Note that there are some crossover of UID and Company ID - as such I am unable to just rename UID as Company ID.  

 

Labels (3)
1 Reply
marcus_sommer

I would merge both ID's into a single ID field directly with a renaming by concatenating the tables + adding an extra source-field + combining these new ID and Source field to get a key-field. This means doing the same on the facts and the dimensions. If there are no further specific reasons I wouldn't include the origin ID fields.