transform un straight table

[#1]

Hello,

I have a table A. Does anyone know how they can t easily transform to table B in Qlikview.

Tableau A
1	A
1	B
2	A
2	B
2	C
3	A
3	B
3	C
3	D
4	C
4	D
4	E
Tableau B
1	AB
2	ABC
3	ABCD
4	CDE

thanks

[lkallioniemi]

Hi,

have You tried Concat -function? It should do the trick.

BR

Lasse

[jonathandienst]

Hi

Try this - given an input source with fields Col1, Col2:

Tableau B:
LOAD 
     Col1,
     Concat(Col2, '') AS OutputCol2
FROM sourcefile
GROUP BY Col1
 ;

Adapt the field names and FROM clause as required for your application.

Hope that helps

Jonathan

[its_anandrjs]

Hi,

Yes you need to work with concat command see the attached sample file.

Reagrds

Anand

[its_anandrjs]

Hi,

If you want TableA and TableB so you need to load with resident and create second table also like

Temp:

LOAD TableA,

     ColB

FROM

Data.xlsx

(ooxml, embedded labels, table is Sheet19);

Data:

LOAD

           TableA as TableB,

     Concat(ColB, '') as ConcatField

Resident Temp

Group by TableA;

See the sample file for clearity

Regards,

Anand