cancel
Showing results for 
Search instead for 
Did you mean: 

Enforce a join to use in Insight

srini_ch
Astronaut

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

1 REPLY 1

Wadeyy03
Ranger

Maybe implement an Alias table for the same and then setup a join and then enforce the said join.