We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Count Different Number in a cell record

Bpan
6 - Meteoroid
‎08-04-2017 02:30 AM

Hi All,

 

I would like to count how many different number in my cell records e.g for "(111) 222 333344", there are 4 different numbers in this record.

 

Any ideas on this will be welcome|

 

Many thanks

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
mborriero
11 - Bolide
‎08-04-2017 02:39 AM

Hi @Bpan, please find attached my approach.

Let me know if you need any explanations.

CountNumberDistinct.yxmd
Reply
0 Likes
Community Live
Live Cloud Quest Solve
Labels
Top Solution Authors
View All