Forum Discussion
Unpivot issue
Hi,
I have files that have different data on the rows. See original file format below. I have multiple files loaded in my PBX file so far. I have created a Category column which I want to use as the column headings. My issues is that when I unpivot I never get whay I need. I required the format on the right 'Required Format'.
In the Query editor select the Category column, then under the Transform->Any Column sub menu click Pivot Column.
In the dialog box that appears change the Values Column to "Column1" from the drop down box
Click on advanced options and choose "don't aggrgate" from the Aggregate Value Function drop down box.
You should get the desired output.
Abhi
Hi,
I think I have solved your problem. Made a video, let me know if it works,
http://www.filedropper.com/groupfrommultipletextfiles
8 Replies
In the Query editor select the Category column, then under the Transform->Any Column sub menu click Pivot Column.
In the dialog box that appears change the Values Column to "Column1" from the drop down box
Click on advanced options and choose "don't aggrgate" from the Aggregate Value Function drop down box.
You should get the desired output.
Abhi
Thank you.
I was using the right click pop-up menu and I could not find the pivot functionality which I needed. However, you answer showed me that it is on the Transform menu and not in the pop-up menu.
Have edited my post to include the location of the Pivot Column option. Cheers.
