ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Concat Down

hellyars
12 - Quasar

Need a little help.  Reference input and output examples below.  I want to clean and concat (down).  

 

UPDATED

 

INPUT:

 

YearStateRecipient
2020CASDACQMD
National  
2020ILALA
NationalIN 
 OH 
2020FLCity of Ocala
National  
2020TX, MO, CADominos
National  

 

DESIRED OUTPUT

 

ProgramYearStateRecipient
National2020CASDACMD
National2020IL, IN, OHALA
National2020FLCity of Ocala
National2020TX, MO, CADominos

 

apathetichell
13 - Pulsar

Is this close?

BrandonB
Alteryx
Alteryx

Similar solution to @apathetichell but potentially more flexible depending on the variety of recipients and programs in your data set. 

 

dynamic.png

hellyars
12 - Quasar

Both solutions work.  The first solution does what I originally asked. The second solution works better for my particular use case (and my revised question). Thank you both. 

Labels