How to "transpose" table in script editor?

[Medea93]

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:

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

[Or · Accepted solution]

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]

What do you mean by "standard method"?

[Or]

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]

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