Forum Discussion
Unpivot issue
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
Have edited my post to include the location of the Pivot Column option. Cheers.
I got the pivot to work. However when there are two sets of data in a file then I get an error "There were too many elements in the enumeration to complete the operation". This happens because there are now duplicates in the Source.Name and the Category columns. I only get the error for file1. I have tried to add an index column which removes the error but the data is then on different rows. I was thinking if instead of an index column maybe a row number for each file might help.
Hi,
I think I have solved your problem. Made a video, let me know if it works,
http://www.filedropper.com/groupfrommultipletextfiles
Wow. Nice one. Thanks you saved me. Perfect.
Hi,
Could you please share the link (Report Directly). The video link what you sent is not visible.