community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

dataset

Asteroid
MEMBER IDTest Done
123NT
123BP
231EE
231NP
145BP
155 

 

To this:

 

MEMBER IDNTEEBP
123YNY
231NYN
145NNY
155NNN

 

 

Thanks

 

Highlighted
Fireball

Hi @Carolyne -

You could cross-tab your data, then use a Multi-Field formula to convert your data to Y or N and then Select to remove unwanted columns. Example is attached.

Labels