Number format problem after joining

koushik_btech20 — Fri, 25 Jan 2013 07:37:50 GMT

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.....

Re: Number format problem after joining

er_mohit — Fri, 25 Jan 2013 09:42:50 GMT

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

topic Re: Number format problem after joining in QlikView

Number format problem after joining

Re: Number format problem after joining