Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have a parent table with 2 child tables. There is a link between parent to child 1 and parent to child 2. But no link between child 1 & child 2.
I want to join all tables into single table
I have done below steps
Table A
Load * from Parent
Left Join
Load * from Child 1
Table B
Load * from Parent
Left Join
Load * from Child 2
Result_Table
Load * from Table A
concatenate
Load * from Table B
From result table if call fields in straight table the data is coming like this
Product | Factory Despatch | Shipment No | EXPCONTRACTID | Qty | Shipment Qty |
---|---|---|---|---|---|
230 | 230 | ||||
Coco Peat Low EC | 60056000105453 | 230 | 0 | ||
SHIPMENT 1 | 60056000105453 | 0 | 115 | ||
SHIPMENT 2 | 60056000105453 | 0 | 115 |
But result should come like
Desired output
Product | Factory Despatch | Shipment No | EXPCONTRACTID | Qty | Shipment Qty |
---|---|---|---|---|---|
230 | 230 | ||||
Coco Peat Low EC | SHIPMENT 1 | 60056000105453 | 230 | 115 | |
Coco Peat Low EC | SHIPMENT 2 | 60056000105453 | 230 | 115 | |
Regards Vignesh
Try This
TableTot:
Load * from Parent;
Left Join
Load * from Child 1;
Left Join
Load * from Child 2;
Let me know
try this
Load parent,
child1
from path;
concatenate
Load parent,
child2
from path;