topic Re: Transpose temp table rows to columns in qlikview script in QlikView

Transpose temp table rows to columns in qlikview script

praveenman54 — Sat, 16 Nov 2024 21:15:59 GMT

Hi Experts,

I am really new to Qlikview and trying to work out how I can transpose rows into columns.

My data looks like this

Empname Organisation flag
ABC Sumo 1
ABC Tata 2
XYZ Sofeti 1
XYZ Tata 2

And I want my result to look like

Empname Organisation1 Organisation2
ABC Sumo Tata
XYZ Sofeti Tata

I am not concerned about the flag column. This data is already in qlikview which is in a temptable. So I cannot use cross load. Please, any help is much appreciate.

Re: Transpose temp table rows to columns in qlikview script

olivierrobin — Tue, 12 Mar 2019 09:22:49 GMT

hello,

if the data is already in qv, can't use binary ?

in that case, you load the data in a new .qvw, in which you could use cross load

Re: Transpose temp table rows to columns in qlikview script

MindaugasBacius — Tue, 12 Mar 2019 10:16:08 GMT

I suggest using Pivot or Straight tables.
Add Dimension Empname.
Add Expression Concat(Organization, ', ').

Re: Transpose temp table rows to columns in qlikview script

techvarun — Tue, 12 Mar 2019 11:10:42 GMT

123:
LOAD * INLINE [
    Empname, Organisation, flag
    ABC, Sumo, 1
    ABC, Tata, 2
    XYZ, Sofeti, 1
    XYZ, Tata, 2
];


124:
Load Empname,Organisation as Organisation1  Resident 123 where flag=1;

125:
Load Empname,Organisation as Organisation2 Resident 123 where flag=2;

126:
Load Distinct Empname Resident 123;

Left Join(126)
Load * Resident 124;


Left Join(126)
Load * Resident 125;

Drop Table 123,124,125;

Try the above code

Re: Transpose temp table rows to columns in qlikview script

praveenman54 — Wed, 13 Mar 2019 09:37:26 GMT

Thanks Varun. It worked for me.