loading columns into rows from excel

[#1]

Hi

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

[sunny_talwar · Accepted solution]

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))

));

[iahamedabdullah]

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()

));

[#4]

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

[sunny_talwar]

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

[#6]

greate super working fine can you elaborate me the logic