Outerjoin and Assign values to the column level

Tue, 27 Apr 2010 21:45:10 GMT

I am loading the data from 2 different tables

Table1
DocumentNo	Item	Material	Qty
1150044791	10000	xxx	1
1150044791	20000	xyz	1
1150044791	20001	zxc	2
1150044791	30000	yyy	2
1150044791	40000	zzz	1
1150044791	40001	xzz	1

Table2
DocumentNo	Item	StartDate
1150044791	0	1/9/2009
1150044791	20001	12/9/2001

If the item has value 0 then I have to assign the StartDate value 1/9/2009 to the below items

10000

20000

30000

40000

40001

Expecting Result :
DocumentNo	Item	Material	Qty	StartDate
1150044791	10000	xxx	1	1/9/2009
1150044791	20000	xyz	1	1/9/2009
1150044791	20001	zxc	2	12/9/2001
1150044791	30000	yyy	2	1/9/2009
1150044791	40000	zzz	1	1/9/2009
1150044791	40001	xzz	1	1/9/2009

Outerjoin I can join both tables .How can I pickup the startdate value from the item 0 and assign the start date values to the below corresponding items

10000

20000

30000

40000

40001

Advance Thanks for your help.

Outerjoin and Assign values to the column level

Wed, 28 Apr 2010 06:29:24 GMT

Hi,

Herewith i have attached a application for your reference.

regards

Rajesh

Outerjoin and Assign values to the column level

Wed, 28 Apr 2010 17:52:57 GMT

Thanks a lot for your support and help.

topic Outerjoin and Assign values to the column level in QlikView

Outerjoin and Assign values to the column level

Outerjoin and Assign values to the column level

Outerjoin and Assign values to the column level