Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

srinivas1921
New Contributor III

matching key field from one table to two fields in another table

Hi All,

please suggest on below scenario and provide any possible solution

we have to compare the key field from one table (Dimension table) to two separate fields in another table (Fact table).

how to compare key field  to fetch the Full name column details ?

Capture2.JPG

Capture1.JPG

 

Regards,

Srinivas

2 Replies
awaisqureshi
New Contributor III

Re: matching key field from one table to two fields in another table

Hi @srinivas1921 ,

 

If I understand you correctly, you want to associate your dimension table with your fact table anywhere CD_Loc is equal to either END_Loc1 or END_Loc2. Is that correct?

If so I believe you can concatenate the table twice and duplicate records to do this (please be careful when aggregating on this table). You can do this by trying something like this.

 

table2:
load
END_Loc1,
[Other Fields]
resident [TableName];

concatenate(table2)
load
End_Loc2 as End_Loc1,
[Other Fields]
resident [TableName];

 

I hope this makes sense, please let me know if I've misunderstood your question.

MVP & Luminary
MVP & Luminary

Re: matching key field from one table to two fields in another table

It looked that you could apply an IntervalMatch.

- Marcus