Alteryx Question

[Padmarao]

I want to combine data from different columns to single column and add data into multiple lines in each row in column so I have written below one and it is not working, can any one help with this?                                                                                                                                

[Class name]+"-"+[Total shares]+\n+[Class name]+"-"+[Voting rights]+\n+[Class name]+"-"+ [Nominal share value]+\n+[Class name]+"-"+[Capital held]+\n+[Class name]+"-"+[Voting %]+\n+[Class name]+"-"+[% of class]

[aatalai]

are the data fields all in string format? If not you might need to change that with a select tool or in the formula use tostring([field])

Hope that helps

[Padmarao]

Yes all are in string format, but still it is not working

[aatalai]

 ok try it without the \n and see where that gets you for starters

[gawa]

hi @Padmarao 

Press enter between " and " where you want to insert a newline.

\n does not work inside Formula expression in Alteryx.  

[Class name]+"-"+[Total shares]+"
"+[Class name]+"-"+[Voting rights]+"
"+[Class name]+"-"+ [Nominal share value]+"
"+[Class name]+"-"+[Capital held]+"
"+[Class name]+"-"+[Voting %]+"
"+[Class name]+"-"+[% of class]

Exapmle