Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.