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.
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
