community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Organize Data

Highlighted
Asteroid

Dear All,

 

i am looking for solution to make the attached current dataset to be looks like the screenshot below, By create a new columns for each Value and each column Values to be either Yes or No or NA or blank based on the current value in the current dataset.

 

Untitled.png

Bolide

Hi @Mostafa_Anwar,

 

Try using the attached workflow. I made this with the assumption that the question attachments are always followed by their answer attachments, so all the 'questions' will be odd attachment numbers and all the 'answers' will be even. I use this odd/even trait in the workflow to help with grouping.

 

Best,

mmenth

Alteryx Certified Partner

@mmenth nailed it! I employed the same methodology in my solution (and didn't post as fast as Megan). I'll go ahead and attach my version to show an alternative way to identify name/value pairings.

 

 

Asteroid

Awesome!

Labels