Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Just wondering is there a way i can join data based on condition?
For Example i have Sales Table and Account info
I need
Load * From Sales
Left Join
Load * From Account
If accountdate > salesdate
I tried this and it does not work any ideas how to do this?
Thanks
No you can't do that but you can do the below
After joining only keep records that match your criteria
Temp:
Load * From Sales
Left Join
Load * From Account
;
Noconcatenate
Fact:
Load *
Resident Temp
Where accountdate > salesdate;
Drop table Temp;