Forum Discussion

srobs's avatar
srobs
Frequent Visitor
2 years ago
Solved

Link Columns as one data source

Hi all,    I'm importing defect data from a JIRA query through a .csv. Some of the JIRA fields have multiple responses, e.g. "Instrument Affected" could have Instrument a, instrument b, instrument...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi srobs ,

    Please try this way:
    Select all of the columns and select "Unpivot Columns":

    Then select "Value" and select "Group By". Make the settings as shown in the following figure:

    The final output is below:

     

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

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

srobs 

maybe unpivoting your table would make things easier for you ? 

 

unpivot your table  from power query : 

step1 :  go to power query

step2 :  select your table

step3 :  go to transform 

step4 :  select the columns from the table you want to unpviot

 

 

step5  : 

 

now you can just use extract between delimiters to and set : ( ) . 

NB : you columns names should all have value that you want to appear in the column inside two (   ) 

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!

It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠