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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.