Vertical data to horizontal format (Transpose of data)

[swatireddy]

Hi All,

I have data in the spreadsheet, 1st column should be considered as a dimension. Alongside's columns data should belong to the particular dimension.

Given Input:

Fileds	data	data1
name	abc	bcd
lastname	a	b
DOB	10-09-1993	16-06-1996
Designation	Manager	developer

Desired Output:

name	lastname	DOB	Designation
abc	a	10-09-1993	Manager
bcd	b	16-06-1996	developer

Thanks in advance 

[Taoufiq_Zarra]

from

Given Input in excel for example

Fileds	data	data1
name	abc	bcd
lastname	a	b
DOB	10-09-1993	16-06-1996
Designation	Manager	developer

then :

output :

[swatimoku]

Hi,

Require the solution for Qliksense. 

Thank you.

[Taoufiq_Zarra]

juste try to copy and paste the code and define the path to the data.

attached the Qliksense version

[eduardo_dimperio]

Hi,

Maybe you can use crosstable.

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

i.e

Crosstable (Month, Sales) LOAD * from ex1.csv;

[swatireddy]

Hi,

Thanks for the solution.

If we are fetching the data from the source system(SQL) how it is possible.

[Richerson]

When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa.

[anushree1]

Looks like the attached solution works only when the source is excel, is there any alternative solution for this issue?

[eduardo_dimperio]

First extract the data to create your aux table, after apply Crosstable  on it, I think that will be the  easier way