Hi Community,
I would like to create an extra column in the QlikSense data load editor, based on multiple other columns.
As an example:
Example_Table:
Load:
ID
Jan
Feb
March
Sales
My data looks like this:
ID JAN FEB MARCH Sales
1 1 0 0 100
2 1 0 0 50
3 0 1 0 75
4 0 1 0 80
As you can see, 'Jan, Feb and March' are one-hot-encoded. I would like to group them into one column, like this:
ID Month Sales
1 JAN 100
2 JAN 50
3 FEB 75
4 FEB 80
Many thanks in advance.
