topic How to transpose a table in App Development

How to transpose a table

Jorghino75 — Sun, 31 Mar 2024 01:17:57 GMT

Hi All

I'm new to QlikView so I'm trying to map out a source file with multiple rows into a table with specific allocation, like a pivot table through the scripts.

I tried a few ways in the LOAD using Sum and Ifs but I get an error using sum and for the total as well.

From a csv file with something like this

into something like this that can be stored into a qvd.

I'm adding a file with sample data.

Any help and guidance would be greatly appreciated.

Re: How to transpose a table

PhanThanhSon — Sun, 31 Mar 2024 08:45:03 GMT

Hi,Here

you'll need the generic load statement, which you'll then need to join afterward. You can refer to Rob Wunderlich's script for guidance on this.

https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/

best regards Son

Re: How to transpose a table

Jorghino75 — Mon, 01 Apr 2024 01:52:40 GMT

Thanks @PhanThanhSon ,

I had to make some tweaks before initiating the generic load but it worked perfectly!