Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
there are two different ITEM Master table with different items. 1st ITEM master has a item which item_code is 18 and in 2nd Item master table has a item which item code is 0018. 18 and 0018 both are different item. When I am joining the two tables I cannot make diffence between 0018 and 18.
use concatenate function
change ur itemcode field into char, chr(ur fieldname)
Hope it helps u.
after concatenating both item_id becomes 0018. But I cannot make difference between 0018 and 18
after using char function the item_id becomes blank.....
try this
LOAD*,
text(ITEM)AS p;
LOAD * INLINE [
ITEM, ITEM_SUB, ITEM_NAME
18, 37, CANDY
20, 40, ABC
21, 55, PQR
];
Join
load*,
Text(ITEM)AS p;
LOAD * INLINE [
ITEM, ITEM_SUB, ITEM_NAME
0018, 88, MNP
30, 90, TUV
27, 92, HOZMOLA
];
hi
plz see the attachement.
actually with the help of text() function we can differentiate 18 and 0018.