topic Re: loading columns into rows from excel in QlikView

loading columns into rows from excel

Wed, 25 Nov 2020 16:16:04 GMT

i have a table as below i want columns as rows

A B D E

employee	aaaa	status	yes
salary	1000	location	india
age	21	type	neutral
role	GM

my output should be as below

employee salary age role status location type

aaa 1000 21 gm yes india neutral

Re: loading columns into rows from excel

sunny_talwar — Tue, 14 Jun 2016 15:09:04 GMT

Not the best ways to do this, by may be this:

Table:

LOAD RowNo() as Key,

employee,

salary,

age,

role

FROM

b.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3))

));

Left Join (Table)

LOAD RowNo() as Key,

status,

location,

type

FROM

b.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 1))

));

Re: loading columns into rows from excel

iahamedabdullah — Tue, 14 Jun 2016 15:13:44 GMT

Do this steps:

Load script --> table Files(Select your Excel file) --> Next --> Enable Transformation Step --> Rotate tab --> Transpose

You will get load script Similar to this:

LOAD employee,

salary,

age

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Transpose()

));

Re: loading columns into rows from excel

Tue, 14 Jun 2016 17:55:46 GMT

hi from the above code i'm getting the above error

Re: loading columns into rows from excel

sunny_talwar — Tue, 14 Jun 2016 17:57:46 GMT

Are you using the Excel file you attached? Have you also checked the path to make sure that path is correct?

Re: loading columns into rows from excel

Tue, 14 Jun 2016 18:06:28 GMT

greate super working fine can you elaborate me the logic