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

2016-04-29_16-41-26.jpg

Krasus
8 - Asteroid

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

Labels