Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
have You tried Concat -function? It should do the trick.
BR
Lasse
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
Hi,
Yes you need to work with concat command see the attached sample file.
Reagrds
Anand
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