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

[srinivas1921]

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 ?

Regards,

Srinivas

[awaisqureshi]

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.

[marcus_sommer]

It looked that you could apply an IntervalMatch.

- Marcus