Simple xml/txt Output Request

[david-r]

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,

[binu_acs · Accepted solution]

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

[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

[david-r]

That works, thank you!