Simple xml/txt Output Request

Hi,

I've a very repetitive task that I'm sure Alteryx and this community could help with.

I have a single excel worksheet (attached) with one column featuring a list of 3 letter iso country codes, I need it exported in xml/txt format, no longer listed but comma seperated on one line. So for example:

ABW
AIA
ALB
ARE
ARG
ATG
AUS
AZE
BES
BHR
BHS

...will be exported in xml or txt format as such:

ABW, AIA, ALB, ARE, ARG, ATG, AUS, AZE, BES, BHR, BHS,

Input

Output

Accepted answers

binu_acs

@david-r one way of doing with the help of summarise tool

summarise_30_05.yxmd

All comments

binu_acs

@david-r one way of doing with the help of summarise tool

summarise_30_05.yxmd

IraWatt

Hey @david-r,

Don't have your worksheet but I think all you need is the summarizes tools concatenate function

Any questions or issues please ask
HTH!
Ira

Example 305.yxmd

david-r

That works, thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703