Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
parvez933
Creator
Creator

Logic Help

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

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Creator
Creator
Author

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