topic Re: Number format problem in QlikView

Number format problem

koushik_btech20 — Fri, 25 Jan 2013 06:58:50 GMT

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.

Re: Number format problem

er_mohit — Fri, 25 Jan 2013 07:06:03 GMT

use concatenate function

Re: Number format problem

khadeer — Fri, 25 Jan 2013 07:08:10 GMT

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

Hope it helps u.

Re: Number format problem

koushik_btech20 — Fri, 25 Jan 2013 07:08:32 GMT

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

Re: Number format problem

koushik_btech20 — Fri, 25 Jan 2013 07:13:11 GMT

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

Re: Number format problem

er_mohit — Fri, 25 Jan 2013 09:45:32 GMT

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

];

Re: Number format problem

Fri, 25 Jan 2013 10:16:24 GMT

plz see the attachement.

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