concatenate two or more applymap fields

[jjking58]

Is there a way to concatenate multple applymap fields.

I would like to create a field call AuthID. which would combine Salesman & Company using the information below

Thanks in advance

InvHeader:

LOAD IHINVN as Inv_Number,

    IHTYPP as DBCR,

    IHSAL2,

    IHCPC2,

    IHSAL3,

    IHCPC3,

    IHXOYN,

    IHCMPD,

    IHMSPC,

    IHMSPL,

    applymap ('Customer',IHCUNO,'nomatch')as NANAME,

    applymap ('Company',IHCUNO,'nomatch')as Company,

    applymap ('Signature',IHSALE,'nomatch')as Salesman,

FROM C:\QlikviewProject\Data Library\Sales\SROISH.qvd

(qvd);

[trdandamudi]

May be as below:

InvHeader:

Load *,

Company&Salesman as AuthID;

LOAD IHINVN as Inv_Number,

    IHTYPP as DBCR,

    IHSAL2,

    IHCPC2,

    IHSAL3,

    IHCPC3,

    IHXOYN,

    IHCMPD,

    IHMSPC,

    IHMSPL,

    applymap ('Customer',IHCUNO,'nomatch')as NANAME,

    applymap ('Company',IHCUNO,'nomatch')as Company,

    applymap ('Signature',IHSALE,'nomatch')as Salesman,

FROM C:\QlikviewProject\Data Library\Sales\SROISH.qvd

(qvd);

[jjking58]

I will try it and let you know,

Thanks

[Anonymous · Accepted solution]

Hi Jim,

try this, using the resident table.

InvHeader:

LOAD IHINVN as Inv_Number,

    IHTYPP as DBCR,

    IHSAL2,

    IHCPC2,

    IHSAL3,

    IHCPC3,

    IHXOYN,

    IHCMPD,

    IHMSPC,

    IHMSPL,

    applymap ('Customer',IHCUNO,'nomatch')as NANAME,

    applymap ('Company',IHCUNO,'nomatch')as Company,

    applymap ('Signature',IHSALE,'nomatch')as Salesman,

FROM C:\QlikviewProject\Data Library\Sales\SROISH.qvd

(qvd);

InvHeader_res:

LOAD IHINVN as Inv_Number,

    IHTYPP as DBCR,

    IHSAL2,

    IHCPC2,

    IHSAL3,

    IHCPC3,

    IHXOYN,

    IHCMPD,

    IHMSPC,

    IHMSPL,

    NANAME,

    Company,   

    Salesman,

    Company&Salesman as AuthID   

Resident InvHeader;

DROP TABLE InvHeader;

[jjking58]

Should there be two loads? I'm get a "Execution Failed" when performing a reload

[Anonymous]

Did you put the "DROP TABLE InvHeader;" statement in at the bottom?

[trdandamudi]

Yes there are two loads and it is called preceding load. I tried a sample like below and it works:

Temp:
Load *,
Id&Name as New;
LOAD Id,
Name,
Amount,
MD,
Combo
FROM

(qvd);

Hope this helps...

[jjking58]

Thank you both for your assistance

I used Matt's suggestion and it worked perfect.

Thanks again

[Anonymous]

Glad to hear it's working Jim!

If you could mark my answer as correct it would be much appreciated.

Thanks