Forum Discussion

GarryFarrell's avatar
GarryFarrell
Advocate III
9 years ago
Solved

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 ...
Need Help
  • Capstone's avatar
    Capstone
    9 years ago

    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

GarryFarrell's avatar
GarryFarrell
Advocate III
9 years ago

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.

Capstone's avatar
Capstone
Resolver I
9 years ago

Have edited my post to include the location of the Pivot Column option. Cheers.

  • GarryFarrell's avatar
    GarryFarrell
    Advocate III
    9 years ago

     

     

     

  • GarryFarrell's avatar
    GarryFarrell
    Advocate III
    9 years ago

     

    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.