Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combination of unpivot and pivot

Hi,

I'm new to Qlik Sense and hope you can help on the way with my first data import.

I have a very wide table, with one row per customer, and one column per variable and period. The data looks something like this:

CUSTOMER_IDVARIABLE_1_LY_P1VARIABLE_1_LY_P2VARIABLE_1_LY_P3....
124812941125232....

For each variable, there's 24 columns, one for each month of this year (TY) and last year (LY). With ~30 variables, that's more than 700 columns. The table has ~200k rows.

I want to transform the data to have on column per variable, and one row per period (so 24 rows per customer instead of one). The end result would be something like this:

CUSTOMER_IDPERIODVARIABLE_1VARIABLE_2...
12481294131.01.201512345...
12481294131.02.201552499

So from what I understand I would have to first do a unpivot (cross table), "split" the variable column to create a period column, and then do a pivot (generic) again to get the variables as columns.

Is this a sensible approach? How should I set up my load script?

Thank you!

2 Replies
vinieme12
Champion III
Champion III

Hi,

please post a data sample, so people here can help you better

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

I have attached a data sample to my original post