Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my input :
ID Jan 20 Feb 20
1 1000 2000
2 2000 2000
I am looking to convert this into something like this below:
ID Month Value
1 01/01/2020 1000
1 02/01/2020 2000
2 01/01/2020 2000
2 02/01/2020 2000
How do I need to script it in Qlik Sense?
Here is shows some examples too -> Working with crosstables in the data load script
Try CrossTable Load
Here is shows some examples too -> Working with crosstables in the data load script