ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Cloud Discussions

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

Can I convert an array to a string?

415d967e4f8db7d6b61f
6 - Meteoroid

I have an array ["Apple","Banana","Cherry"]

 

which I need to convert to a string Apple,Banana,Cherry making it more user friendly on a report.

 

Any quick way to do this?  (I am able to convert the array to a string, then remove characters, but would like to find a cleaner solution.)

5 REPLIES 5
Trifacta_Alumni
Alteryx Alumni (Retired)

Hi @Lorie G? 

You can accomplish this by using the "ArrayMergeElement" function, please follow the below screenshot steps:

I hope this helps

Thanks

Rohit Bhaskar

415d967e4f8db7d6b61f
6 - Meteoroid

Thank you, @Rohit Bhaskar (Trifacta)?  Your solution resolved my issue. Much appreciated!

Trifacta_Alumni
Alteryx Alumni (Retired)

Hi @Lorie G? 

I am glad that it helps :)

The toString() method is used for converting and representing an array into string form.

TrifactaUsers
10 - Fireball

Sometimes we need to convert an array of strings or integers into a string, but unfortunately, there is no direct method to perform this conversion. The default implementation of the toString() method on an array returns something like Ljava.