convert a vertical table to horizontal table

[Anonymous]

Hi Qlik Community,

Can someone assist with the below please?

I have a "vertical" table like this:

Data Table:

Ordernumber      OrderLineNumber        Entity          Value

10000054           1                               artcode        4911731130608

10000054           1                               amount        3

10000054           1                               price           7,828

.......

How to load these data to Qlik as one row:

Ordernumber        OrderLineNumber      Artcode                 Amount      Price

10000054             1                             4911731130608      3                7,828

...........

[nsetty]

Generic is a way to solve.

Please check below link

The Generic Load

[vamsee · Accepted solution]

Hello,

Refer

The Generic Load

A:

Generic Load

Ordernumber,

OrderLineNumber,

Entity,

Value

;

LOAD * Inline [

Ordernumber,      OrderLineNumber,        Entity,         Value

10000054,          1,                               artcode,        4911731130608

10000054,          1,                               amount,        3

10000054,          1,                               price,          7,828

];

Final:

NoConcatenate

LOAD

Ordernumber,

OrderLineNumber,

price

Resident A.price;

Join(Final)

LOAD

Ordernumber,

OrderLineNumber,

amount

Resident A.amount;

Join(Final)

LOAD

Ordernumber,

OrderLineNumber,

artcode

Resident A.artcode;

DROP Tables A.artcode,A.amount,A.price;

Thanks.

[Anonymous]

Fantastic, Vamsee!

Thanks, that's what I need!

AO