Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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