Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I had a scenario where i need to make rows into columns in qlikview.
For Ex:
My source .xlsx has below data
company name account number 1 account number 2 account number 3
ABC 1 2 3
CDE 8 10
My output should be:
company name account number
ABC 1
ABC 2
ABC 3
CDE 8
CDE 10
Could you please help me on above.
Thanks,
Pavan
Sounds like you need the CrossTable() function which is explained in the Blog Post.
HI
Try like
crosstable(AccountName, AccountNumber, 1)
Load * from yourtablename;
Have you looked at CrossTable() Load? Check it out: The Crosstable Load
CrossTable([Acc 1], [Account No.])
LOAD Company,
[Acc 1],
[Acc 2],
[Acc 3]
FROM
(
use this script for cross table or do the below steps while loading table
use crosstable function ;