Re: Hi all let me clarify my doubt about tables - Qlik Community

Report Inappropriate Content · ‎2014-05-22

Hi,

I have a parent table and two different child tables, i want to merge two child tables with parent table.

For example

Table 1 (Parent) Table 2 (Child 1) Table 3 (Child 2)

ParentID, Invoice_No, date Parentid, Child1id, Product, Qty, Rate, parentid, Child2id Shipment_Date, Dispatch_Date,

Ship 1 Inv 1 25/05/2014 Ship 1 1234, xxxxxxx, 50 400 Ship 1, 4321 30/05/2014 28/05/2014

I done left join parent table with child 1 table, Similarly child 2 table. I got link Parent &child 1 , Parent &child 2 these two tables i have done concatenate so i got single table.

If i call fields from child 1 & child 2 in straight table then its come in two rows mentioned below

Invoice_No Date Product qty Rate Shipment_date Dispatch_Date

Inv 1 25/05/2014 xxxxxxx, 50 400 - -

- - - - - 30/05/2014 28/05/2014

desired output

it should be come

Invoice_No Date Product qty Rate Shipment_date Dispatch_Date

Inv 1 25/05/2014 xxxxxxx, 50 400 30/05/2014 28/05/2014

Regards

Vignesh

Anonymous · ‎2014-05-22

Hi,

check this attachment.

HTH

Regards,
Ravi N.

Report Inappropriate Content · ‎2014-05-22

Hi Ravi,

Not able to open your qvw, i think it is personal edition.

Regards

Vignesh

marcus_malinow · ‎2014-05-22

Vignesh,

First off based on your output above it looks like your join from parent to child 2 might not be working correctly as you have a record there with no Invoice no, but with shipment and dispatch dates. Check that the parent id field is named the same in the loads from parent and child 2.

Secondly, I'd suggest loading parent, then left joining child 1, then left joining child 2 onto the resulting table, rather than concatenating.

Marcus