Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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