topic Re: concatenate two or more applymap fields in QlikView

concatenate two or more applymap fields

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: concatenate two or more applymap fields

trdandamudi — Thu, 18 May 2017 14:42:05 GMT

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);

Re: concatenate two or more applymap fields

jjking58 — Thu, 18 May 2017 14:47:30 GMT

I will try it and let you know,

Thanks

Re: concatenate two or more applymap fields

Anonymous — Thu, 18 May 2017 14:51:31 GMT

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;

Re: concatenate two or more applymap fields

jjking58 — Thu, 18 May 2017 15:06:29 GMT

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

Re: concatenate two or more applymap fields

Anonymous — Thu, 18 May 2017 15:10:07 GMT

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

Re: concatenate two or more applymap fields

trdandamudi — Thu, 18 May 2017 15:11:41 GMT

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

Re: concatenate two or more applymap fields

jjking58 — Thu, 18 May 2017 15:31:40 GMT

Thank you both for your assistance

I used Matt's suggestion and it worked perfect.

Thanks again

Re: concatenate two or more applymap fields

Anonymous — Thu, 18 May 2017 15:35:16 GMT

Glad to hear it's working Jim!

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

Thanks