Number format problem after joining

[koushik_btech20]

There are two different inline table:

ITEMMASTER:

LOAD * INLINE [

    ITEM_ID, ITEM_SUB_ID, ITEM_NAME

    18, 37, candy

    20, 40, abc

    21, 55, pqr

];

OTEHRITEMMASTER:

NoConcatenate

LOAD * INLINE [

    ITEM_ID, ITEM_SUB_ID, ITEM_NAME

    0018, 88, mnp

    30, 90, tuv

    27, 92, hozmola

];

Now I want join two tables and  the output will be as :

ITEM_ID,ITEM_SUBID,ITEM_NAME

18,37,candy

0018,88,mnp

20,40,abc

21,55,pqr

27,92,hozmola

30,90,tuv

I cannot make difference between item_code 18 and 0018 after joining. If anyone have the solution please share.....

[er_mohit · Accepted solution]

hiiii

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

];

hope it helps.

see the attached fie