Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Concatenate master detail fact tables

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

1 Solution

Accepted Solutions
salto
Valued Contributor II

Re: Concatenate master detail fact tables

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

3 Replies
salto
Valued Contributor II

Re: Concatenate master detail fact tables

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

cabhijit
Valued Contributor

Re: Concatenate master detail fact tables

Use Join instead on Concatenate

Not applicable

Re: Concatenate master detail fact tables

Thanks to all

The issue is resolved with Left Join.