how to convert rows data into Columns

[lakshman1031]

Hi All,

I have fields like

Load ID, Category, Actuals_date, Planned_Date from ID.qvd;

Category field  having values category1, Category2, Category3

I want to convert Category field values as columns like category1, Category2 like that.

I am trying to use generic load, but its having separate for each table.

But my requirement is all the field coming in single table like

ID,Category1,category2,category3,Actuals_Date from table ;

Can you please suggest me how to do this scenario.

Thanks & Regards,

Lakshman  

[marcus_sommer]

The handling of crosstables has usually serious disadvantages against normal data-structures and has only within very specific scenarios a benefit. Therefore make sure that a crosstable is mandatory for the next transformations.

Beside this take a look on this post: The Generic Load - Qlik Community - 1473470 in which in the end is shown how to merge the n tables into a single table again.