topic Re: transform un straight table in QlikView

transform un straight table

Thu, 01 Sep 2011 09:19:31 GMT

Hello,

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

thanks

lkallioniemi — Thu, 01 Sep 2011 10:09:24 GMT

Hi,

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

Lasse

jonathandienst — Thu, 01 Sep 2011 10:17:07 GMT

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 — Thu, 01 Sep 2011 10:22:20 GMT

Hi,

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

Reagrds

Anand

its_anandrjs — Thu, 01 Sep 2011 10:29:48 GMT

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