It would be great if anyone could help me to join data from 3 source types:
1) sourcetype_1 has fields AA,MM,CC,Amt1
2) sourcetype_2 has fields AA,mm,ss
3) sourcetype_3 has fields SS,cc,Amt2
Step 1 - Join first and second source type where sourcetype_1.AA == sourcetype_2.AA && sourcetype_1.MM=sourcetype_2.mm
Step 2 - Join result of step 2 and third source type where sourcetype_3.cc= step1.CC and sourcetype_3.SS = Step1.ss
In my final result, I want to group by OO, CC and SS and show all the CC and SS where Amt2 is lesser than Amt
Note - There is a many-to-many relationship between some of the required fields.
Thanks in advance!
... View more