Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

joining tables

Hii,

I have question on two tables. I have one table that has budget and actual sales data for year with some dimensions and i have another table in different file which has forecast for the present year. now I have to create a dashboard using these two files.

When I think of joining these two tables then I think there will be an issue because second table has a few dimensions but not all so it will give me null values. ANY THOUGHTS ON IT???

2 Replies
Clever_Anjos
Employee
Employee

Usually I concatenate them

krishnacbe
Partner - Specialist III
Partner - Specialist III

Try to create Concatenate Key/Column and join.