topic Re: Convert vertical columns to Horizontal in QlikView

Convert vertical columns to Horizontal

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

Hi,

I have the data in vertical rows which i like to convert to horizontal data columns

Below is the screenshot of the sample of the input and the required output

The data is dynamically retrieved from the table and I like this conversion through load script

Can you pl provide some inputs in cross table usage in loadscript for this conversion

Thanks

arvind_patil — Sat, 01 Sep 2018 06:21:22 GMT

Hi Umashakar,

Try to using pivot table you will get same.

Thanks,

Arvind Patil

andrey_krylov — Sat, 01 Sep 2018 06:25:42 GMT

Hi, Umashankar. To achieve this you can use Generic LOAD

GenTable: Generic Load NBR, Group, Count Resident InputTable;

ResultTable: LOAD Distinct NBR Resident InputTable;

FOR i = 0 to NoOfTables()

TableList:

LOAD TableName($(i)) as Tablename AUTOGENERATE 1

WHERE WildMatch(TableName($(i)), 'GenTable.*');

NEXT i

FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));

LEFT JOIN (ResultTable) LOAD * RESIDENT [$(vTable)];

DROP TABLE [$(vTable)];

NEXT i

DROP TABLES TableList, InputTable;

BalaBhaskar_Qlik — Sat, 01 Sep 2018 14:44:25 GMT

Anonymous — Sat, 01 Sep 2018 18:02:35 GMT

Make use of the pivot. It'll be easier.

qlikviewwizard — Sun, 02 Sep 2018 04:34:37 GMT

Hi,

Please check this.

umashankarus — Tue, 04 Sep 2018 08:56:04 GMT

Thanks for the response