Logic Help

[parvez933]

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

[dplr-rn]

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;

[parvez933]

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