topic Re: Logic Help in QlikView

Logic Help

parvez933 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Logic Help

dplr-rn — Mon, 28 Sep 2020 17:06:02 GMT

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;

Re: Logic Help

parvez933 — Tue, 29 Sep 2020 04:54:35 GMT

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