Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.