Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find the below sample code
Party_Fact:
Load
MDM_ID,
Party_NM;
Select
MDM_ID,
Party_NM
from partyfact.sql;
Party_Merge:
Load
RecoveryID,
OriginalID,
StartDate;
Select
RecoveryID,
OriginalID,
StartDate
from partymerge.sql;
The ask is create a Party_Merge sheet on the front end and enable table with the below fields
RecoveryID | RecoveryPartyName | OriginalID | OriginalPartyName | StartDate
We have to get the RecoveryPartyName from Party_NM (from Party_Fact Table), where the MDMID = RecoveryID [Suggestion was to join both the tables to get the RecoveryPartyName].
And we have to get the OriginalPartyName from Party_NM (from Party_Fact Table), where the MDMID = OriginalID [Suggestion was to join both the tables to get the OriginalPartyName].
So, I have been trying many things, it would be great if someone can guide.
Regards,
Parvez
add below to your script
left join (Party_Merge) // you can comment the join and leave this as dimension table too
load
MDM_ID as RecoveryID,
Party_NM as RecoveryPartyName
resident Party_Fact;
left join (Party_Merge) // you can comment the join and leave this as dimension table too
load
MDM_ID as OriginalID,
Party_NM as OriginalPartyName
resident Party_Fact;
drop table Party_Fact;
Hi Dilipranjith!
Thank You, for sharing the code.
Based on above logic, the Start Date will gets filtered when we take in a table?
RecoveryID | RecoveryPartyName | OriginalID | OriginalPartyName | StartDate
Regards,
Parvez