topic Re: Rows into columns in QlikView

Rows into columns

pavanqlik — Wed, 10 Feb 2016 09:19:34 GMT

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

Anonymous — Wed, 10 Feb 2016 11:27:44 GMT

Sounds like you need the CrossTable() function which is explained in the Blog Post.

MayilVahanan — Wed, 10 Feb 2016 11:29:09 GMT

Try like

crosstable(AccountName, AccountNumber, 1)

Load * from yourtablename;

sunny_talwar — Wed, 10 Feb 2016 11:32:24 GMT

Have you looked at CrossTable() Load? Check it out: The Crosstable Load

ajayrai — Wed, 10 Feb 2016 11:34:47 GMT

CrossTable([Acc 1], [Account No.])
LOAD Company,
[Acc 1],
[Acc 2],
[Acc 3]
FROM

(ooxml, embedded labels, table is Sheet2);

use this script for cross table or do the below steps while loading table

avinashelite — Wed, 10 Feb 2016 12:09:58 GMT

use crosstable function ;