topic Re: Transpose data in data script in QlikView

Transpose data in data script

Amelia_96 — Fri, 20 Nov 2020 18:58:42 GMT

Hi, i'm trying to transpose data but making it distinct by ID. Is there anyone who knows how to do this in qlikview script?

Here is the sample data:

Here is the expected output:

Please help. Thank you in advance!!

Re: Transpose data in data script

MayilVahanan — Mon, 09 Nov 2020 07:04:46 GMT

Hi @Amelia_96

Try like below.

T1:
Load * Inline
[
ID, Category
a1, small
a1, medium
a1, large
a2, small
a3, medium
a3, large
a4, small
a5, small
a5, medium
a5, large
a5, extra large
];

Drop table T1;

Re: Transpose data in data script

Amelia_96 — Mon, 09 Nov 2020 09:54:42 GMT

Thank you so much. This helps a lot.