Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Combining Multiple Columns into one

Highlighted
5 - Atom

I have data similar to the example below

AccountJillMikeJohn
1aa 
2 b 
3ccc
4  d

and I would like

AccountData
1a
2b
3c
4d

 

Any ideas how to combine these columns and eliminate nulls? Preferably without a big if function as I actually have about 15 columns with data like this to combine

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@jill ,

 

Please follow these steps:

 

  1. TRANSPOSE - Key Column = Account
  2. FILTER - Use this formula to get rid of blanks

 

 

!IsEmpty(Trim([Value]))

 

 

  • SUMMARIZE - Group by Account, Value MODE
    I use mode for the most frequently occurring value.

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels