Convert vertical columns to Horizontal

[umashankarus]

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]

Hi Umashakar,

Try to using pivot table you will get same.

Thanks,

Arvind Patil

[andrey_krylov · Accepted solution]

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;

[balabhaskarqlik]

The Generic Load

[Anonymous]

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

[qlikviewwizard]

Hi,

Please check this.

[umashankarus]

Thanks for the response