Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

koushik_btech20
Contributor

Number format problem after joining

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

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Number format problem after joining

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

1 Reply
er_mohit
Honored Contributor II

Re: Number format problem after joining

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

Community Browser