Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can i list all characters in one file (no repeat)

Krasus
8 - Asteroid

Hello,

 

I need to summarize a file and list all characters once.

 

For example, i have a text file with one sentence  "Hello world!" and then we can get "helowrd!" in my output.

or maybe output like this?

h
e
l
o
w
r
d
!
 

 

Any one have a excellent idea for me?

 

Thanks!

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

A quick go:

 

- Use a RegexTool in Tokenise to Rows on .

- Add A Record Id (for Ordering)

- Get Unique Letters

- Reorder on Record Id

- Concatenate with Summarise

undefined

Krasus
8 - Asteroid

Thanks again! U r my god!!!!Smiley Very Happy

Labels
Top Solution Authors