11-21-2022 09:50 AM
Hi Community,
Scenario: Let's consider that we have tables A, B, C, D, and Z and the joins between them are as follows and are in the same order as follows,
C --> Z
D --> Z
A --> Z
B --> Z
We have other joins between tables A, B, C & D. We have all these tables being used in the insight, where the insight uses C --> Z join, but I want to enforce the join A --> Z to be used. I tried adding the base column, but it didn't work.
Is there any other that I could use?
Thanks,
Srini
04-06-2023 07:16 AM
Maybe implement an Alias table for the same and then setup a join and then enforce the said join.