We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Account mapping across multiple fields

tiverson
8 - Asteroid

I have a table of accounts for multiple companies and need to assign the description to my data by ARE.

 

Thanks!

 

Account listing by ARE 

tiverson_0-1648646470100.png

 

 

Data

tiverson_1-1648646470209.png

 

 

Output

tiverson_2-1648646470211.png

 

 

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @tiverson 

 

Here's how:

  1. Transpose your lookup data so the acct types are rows instead of columns
  2. Join the data by ARE and Acct number
  3. Union the fall outs for AREs/Accounts that didn't join

 

Luke_C_0-1648646854092.png

 

 

tiverson
8 - Asteroid

@Luke_C , awesome.  Thanks for the quick reply!

Labels
Top Solution Authors