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.

Anonymous's avatar
Anonymous
Not applicable
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.

srobs's avatar
srobs
Frequent Visitor
2 years ago

Hi, 

 

I've found a way to show what I wanted now!

I used this to unpivot and then removed the blanks and I can display the data by instrument type.

 

Thanks for your help.