Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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;
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);
I will try it and let you know,
Thanks
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;
Should there be two loads? I'm get a "Execution Failed" when performing a reload
Did you put the "DROP TABLE InvHeader;" statement in at the bottom?
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
(
Hope this helps...
Thank you both for your assistance
I used Matt's suggestion and it worked perfect.
Thanks again
Glad to hear it's working Jim!
If you could mark my answer as correct it would be much appreciated.
Thanks