topic Concat string during load statement in qlik view script in QlikView

Concat string during load statement in qlik view script

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

Hi friends,

I have a table contain name and type. i just want to concat A and B in each name during load script in qlik view as attached screenshot for your reference.

Re: Concat string during load statement in qlik view script

vishsaggi — Fri, 02 Mar 2018 18:45:59 GMT

‌try this

Load name&’A’ as Name, type

from yoursource;

LOad name&’B’ as Name, type

from yoursource;

Re: Concat string during load statement in qlik view script

krishnacbe — Fri, 02 Mar 2018 19:12:45 GMT

Try below Script.

Temp_Data:
LOAD Name,
Type
FROM
\\NAEAST.AD.JPMORGANCHASE.com\AmerXBUS$\xbus\NAVAVDIHOME36\N649020\jpmDesk\Desktop\Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
Data:
Load *,
Name & 'A' as Name1
Resident Temp_Data;
concatenate
Load *,
Name & 'B' as Name1
Resident Temp_Data;

drop table Temp_Data;

Re: Concat string during load statement in qlik view script

MarcoWedel — Fri, 02 Mar 2018 19:42:44 GMT

Hi,

one solution might be also:

table1:
LOAD Name&Pick(IterNo(),'A','B') as Name,
    Type
INLINE [
    Name, Type
    Name1, Type1
    Name2, Type2
    Name3, Type3
] While IterNo()<=2;

hope this helps

regards

Marco