Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago

grouping into different columns

I am trying to seperate a column work order tag reason when the WO order number is the same, see example, it would break it out into different columns.  The last 4 rows are the same work order number, so those would have the Tag Reasons seperated into seperate columns.  all other fields would stay the same.  

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Please provide sample data in usable format (not as a picture) , show the expected outcome, and give sufficient context.

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    5 years ago

    lbendlin See below  and appreciate your help.  Essentially what I am trying to do is sort of pivot the Work order tag reason column / split it when the work order number matches.  



  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, @jcastr02 

     

    According to your description, the requirement is inconsistent with the PQ function calculation logic. For example, the order number you provided has four rows that require four custom columns. If other order numbers have many rows that are not repeated, how many additional custom columns should be added? If you do this is to realize an idea in the report, you can put it forward and let me see if i can help you.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.