instead of null i want values

[Srinivas]

Hi All,

See below data, Here i have Num,Item_Type. and Type

Type have null values so instead of null values i want ITEM_TYPE values.

NUM	ITEM_TYPE	Type
17721	fast food	-
17722	fast food	-
17723	fast food	-
17724	fast food	-
17725	fast food	-
17726	fast food	-
17727	fast food	-
17728	fast food	-
17729	fast food	-

Regards

Munna

[jagan]

Hi Munna,

Try like this

Temp:
LOAD *

FROM Table1;

Left Join(Temp)

LOAD *

FROM Table2;

Data:
Load

Num,

ITEM_TYPE,
if(Len(Trim(Type)) = 0 OR Type='-', ITEM_TYPE, Type) AS Type
Resident Temp;
DROP Table Temp;

Hope this helps you.

Regards,

Jagan.

[jagan]

Or Try mapping load

TypeMapping:

Mapping LOAD

Num, Type

FROM Table2

WHERE Len(Trim(Type)) > 0 OR Type <> '-';

Data:
LOAD

Num,

ITEM_TYPE,

ApplyMap('TypeMapping', Num,  ITEM_TYPE) AS Type

FROM Table1;

Hope this helps you.

Regards,

Jagan.