Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

koushik_btech20
Not applicable

Number format problem

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.

6 Replies
er_mohit
Not applicable

Re: Number format problem

use concatenate function

khadeer_sparks
Not applicable

Re: Number format problem

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

Hope it helps u.

koushik_btech20
Not applicable

Re: Number format problem

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

koushik_btech20
Not applicable

Re: Number format problem

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

er_mohit
Not applicable

Re: Number format problem

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

];

Not applicable

Re: Number format problem

hi

plz see the attachement.

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