Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks @PhanThanhSon ,
I had to make some tweaks before initiating the generic load but it worked perfectly!
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
Thanks @PhanThanhSon ,
I had to make some tweaks before initiating the generic load but it worked perfectly!