Concat string during load statement in qlik view script

[praveenkumar_s]

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.

[vishsaggi]

‌try this

Load name&’A’ as Name, type

from yoursource;

LOad name&’B’ as Name, type

from yoursource;

[krishnacbe]

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;

[MarcoWedel]

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