Forum Discussion
Use Column Name as Filter
Guys, I have a dataset like this: Customer ID onsite/offshore Region 01-01-2011 01-02-2011 01-03-2011 01-04-2011 Customer1 onsite Kuwait 200000 200000 200000 300000 Custo...
Bhoobala_P No need to Duplicate the table
In the Query Editor
1) Transform tab => Use First Row as Headers (if necessary)
2) select Customer ID, onsite/offshore and Region Columns => Unpivot Other Columns
3) Rename New Columns (if necessary) Attribute to Date
4) Close and Apply
Here's the result...
And...
Hope this helps.
Good Luck! :smileyhappy:
Hello,
because of this solution data size will increase let's say we have 1 billion records if we unpivot it then it will convert in 4 Billion. This is not feasible. Actually, I am also facing this issue. Can you suggest me a better solution?
Thanks in advance