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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Moving content in specific columns based on criteria

Meteoroid

Hello all,

 

Got a bit of a weird one for you - We have survey data completed where respondants can complete the survey in English or French. If they choose English, they answer questions 1-5 (each of which is an individual column). If they answer French, questions 1-5 remain NULL and they answer answers 6-10. 

 

However, we are analysing the data in aggregate, regardless of language. 

 

I am trying to do something like: 

If respondant chose English, then columns 1-5 are the english answers

If respondant chose French, then columns 6-10 (containing the answers) are swapped with columns 1-30 (which are NULL).

 

Thank you!

 

Any advice? 

Bolide
Bolide

The simplest example I can think of is to manually filter Language = "French". In that "true" path, remove 1-5 and rename 6-10 as 1-5 using a select tool. in the "false" path (english), deselect the fields 6-10 in a select tool and then union both together selecting "auto position by name".

Meteoroid

Wow... i guess it's been a long day. So simple! Thanks so much for the quick response  

Labels