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.