Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Link Table

Hello,

I have 2 tables, 1 from each data source that both have a Region field.  I also have an intermediate table linking these 2 tables together, defining a hierarchy for 3-4 other fields.

 

When I try to pull Region from both tables, I get the craziest results.  

 

Is there a way that I can keep the intermediate table to define the hierarchy and still pull region info from both tables.

 

1 table is Savings and 1 is Spend.

 

Thanks

Labels (2)
1 Reply
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

It sounds to me like you probably don't need the link table. Why not concatenate both tables? And have [%DataType] field to identify the data source for Set Analysis in UI

 

Let me know if it helps