Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Medea93
Contributor II
Contributor II

How to "transpose" table in script editor?

Hi everybody,

I know this question has been asked already but it was quite different from what I am looking for.

I have a table like this:

 

Medea93_0-1696239851081.png

 

I want it becomes something like this:

  F1 F2 F3
01/01/2023        196,2        184,2        155,1
01/02/2023        174,3        172,9        144,2
01/03/2023        139,8        152,0        124,7
01/04/2023        135,5        152,0        126,4
01/05/2023        110,0        119,8           95,1

 

Is that possible through data load editor?

Thank you

 

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

First, load the table splitting the yearmonth field into left(Field,6) and Right(Field,2). You can then use the standard method to pivot the table by the second field, so this is really just the standard question with an extra step required first.

View solution in original post

4 Replies
Or
MVP
MVP

First, load the table splitting the yearmonth field into left(Field,6) and Right(Field,2). You can then use the standard method to pivot the table by the second field, so this is really just the standard question with an extra step required first.

Medea93
Contributor II
Contributor II
Author

What do you mean by "standard method"?

Or
MVP
MVP

I assumed you already knew that, since you mentioned that you looked it up but it didn't fit what you needed...

https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470

 

Medea93
Contributor II
Contributor II
Author

Thanks, didn't get what you meant at first.

I have indeed used "Generic Load" after the split you've suggested and it worked.

Many thanks