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: 
datagrrl
Creator III
Creator III

Adding missing values to a dimension table from fact table

I have a situation where my User Dimension is basically internal contacts, but external contact records are also in my fact table.
I want to add values from the fact table that are missing from the dimension table so that I will have a complete User Dimension. The Title for my external user would be something like 'Outside Sales'.
I included a Dummy App. I feel like this is easier than I am making it. I have tried a couple things with join and concatenate and I end up getting the wrong results.
Any assistance is appreciated.

 

datagrrl_0-1731079352642.pngdatagrrl_1-1731079389837.png

 

Labels (1)
10 Replies
datagrrl
Creator III
Creator III
Author

I tried to mark both as the solution since you posted at the same time. Thanks for the help.