https://community.qlik.com/t5/App-Development/Link-Table/m-p/1509124#M44070 <P>Hello,</P><P>I have 2 tables, 1 from each data source that both have a Region field.&nbsp; I also have an intermediate table linking these 2 tables together, defining a hierarchy for 3-4 other fields.</P><P>&nbsp;</P><P>When I try to pull Region from both tables, I get the craziest results.&nbsp;&nbsp;</P><P>&nbsp;</P><P>Is there a way that I can keep the intermediate table to define the hierarchy and still pull region info from both tables.</P><P>&nbsp;</P><P>1 table is Savings and 1 is Spend.</P><P>&nbsp;</P><P>Thanks</P> Sat, 16 Nov 2024 07:15:53 GMT Anonymous 2024-11-16T07:15:53Z https://community.qlik.com/t5/App-Development/Link-Table/m-p/1509124#M44070 <P>Hello,</P><P>I have 2 tables, 1 from each data source that both have a Region field.&nbsp; I also have an intermediate table linking these 2 tables together, defining a hierarchy for 3-4 other fields.</P><P>&nbsp;</P><P>When I try to pull Region from both tables, I get the craziest results.&nbsp;&nbsp;</P><P>&nbsp;</P><P>Is there a way that I can keep the intermediate table to define the hierarchy and still pull region info from both tables.</P><P>&nbsp;</P><P>1 table is Savings and 1 is Spend.</P><P>&nbsp;</P><P>Thanks</P> Sat, 16 Nov 2024 07:15:53 GMT https://community.qlik.com/t5/App-Development/Link-Table/m-p/1509124#M44070 Anonymous 2024-11-16T07:15:53Z https://community.qlik.com/t5/App-Development/Link-Table/m-p/1509235#M44071 <P>Hi,</P><P>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</P><P>&nbsp;</P><P>Let me know if it helps</P> Mon, 19 Nov 2018 17:31:27 GMT https://community.qlik.com/t5/App-Development/Link-Table/m-p/1509235#M44071 Gabriel 2018-11-19T17:31:27Z