Survey with Alteryx - how to combine more than 3 columns in one

[Malek22]

Hello everyone, 

 I'm trying to create workflow to provide the results of surveys. The formula of the results depends on the average on each question. 

 For example: 

 Malek - question 1 the average is 4 then the message is Well done Malek you're good listener 

              question 2 the average is 2.5 then the message is you need to focus on technical ..etc 

 I want the results to show these messages in one cell and the results to populated as per the below: 

 Malek - well done Malek you're good listener but you need to focus on technical 

 I have done the mapping of the average and but I have issue how to combine the messages for each column ? 

 Thank you 

[ShankerV]

hi @Malek22 

I was able to see only the workflow. Not how the input looks like.

We can achieve combining 3 columns with the help of Formula tool.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @Malek22 

If you are looking similar to this, 

Formula

[Field1]+ " - "+ [Field2]+" but "+[Field3]

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[Malek22]

Hi @ShankerV  , 

 Thank you for your response. But I need the message to be combined in one cell but separated from the low and high, to combine the good message in once and the bad in a once as well 

[ShankerV]

Hi @Malek22 

Sure, its possible.

But need more samples and expected output for good and negative.

so I can do it and share it to you.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Malek22 One way of doing this is with the help of the summarize tool concatenate option. Attaching a sample workflow for your reference

[Malek22]

Many thanks @binuacs , that works fine with me :)