Solved: Concatenate master detail fact tables - Qlik Community

Report Inappropriate Content · ‎2014-08-28

Hi

I have master detail fact tables. due to some reason I want to concatenate both of them in one table. I did this by using Concatenate command. the problem is CustomerID is present in all Master Rows and not in Detail rows. How to update CustomerID in all rows of a Order?

Regards

Rizwan

salto · ‎2014-08-28

Hello Rizwan,

I suppose you have a field that links both Master and Detail Rows.

In such case, maybe a left join Master -> Detail can be a good option, instead of concatenating both facts table. Then every row (Master and Detail) will have the CustomerID field informed.

Hope this helps!

View solution in original post

salto · ‎2014-08-28

Hello Rizwan,

I suppose you have a field that links both Master and Detail Rows.

In such case, maybe a left join Master -> Detail can be a good option, instead of concatenating both facts table. Then every row (Master and Detail) will have the CustomerID field informed.

Hope this helps!

AbhijitBansode · ‎2014-08-28

Use Join instead on Concatenate

Report Inappropriate Content · ‎2014-08-29

Thanks to all

The issue is resolved with Left Join.