Discussion board where members can get started with QlikView.
i have a table as below i want columns as rows
A B D E
my output should be as below
employee salary age role status location type
aaa 1000 21 gm yes india neutral
Go to Solution.
Not the best ways to do this, by may be this:
LOAD RowNo() as Key,
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3))
Left Join (Table)
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1))
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:
hi from the above code i'm getting the above error
Are you using the Excel file you attached? Have you also checked the path to make sure that path is correct?
greate super working fine can you elaborate me the logic