I need clarifications to joining tables

Fri, 30 May 2014 12:00:59 GMT

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	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	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

Re: I need clarifications to joining tables

alexandros17 — Fri, 30 May 2014 12:02:25 GMT

Try This

TableTot:

Load * from Parent;

Left Join

Load * from Child 1;

Left Join

Load * from Child 2;

Let me know

preminqlik — Fri, 30 May 2014 12:07:06 GMT

try this

Load parent,

child1

from path;

concatenate

Load parent,

child2

from path;