Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 :
Hi,
Require the solution for Qliksense.
Thank you.
juste try to copy and paste the code and define the path to the data.
attached the Qliksense version
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;
Hi,
Thanks for the solution.
If we are fetching the data from the source system(SQL) how it is possible.
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.
Looks like the attached solution works only when the source is excel, is there any alternative solution for this issue?
First extract the data to create your aux table, after apply Crosstable on it, I think that will be the easier way