Forum Discussion
GarryFarrell
Advocate III
Advocate IIIUnpivot 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 ...
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
Capstone
Resolver I
Resolver IHave edited my post to include the location of the Pivot Column option. Cheers.
GarryFarrellAdvocate III
Advocate III