Number format problem

[koushik_btech20]

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.

[er_mohit]

use concatenate function

[khadeer]

change ur itemcode field into char, chr(ur fieldname)

Hope it helps u.

[koushik_btech20]

after concatenating both item_id becomes 0018. But I cannot make difference between 0018 and 18

[koushik_btech20]

after using char function the item_id becomes blank.....

[er_mohit]

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

];

[#7]

hi

plz see the attachement.

actually with the help of text() function we can differentiate 18 and 0018.