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.

Account mapping & List box Interface tool

tiverson
8 - Asteroid

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

Once the data has been assigned an Account type, how do I create an interface with a list box to select which account types AND the periods I want my workflow to run for?  

Thanks!

 

Account listing by ARE 

tiverson_0-1648556102537.png

 

Data

tiverson_1-1648556142171.png

 

Output

tiverson_2-1648556161565.png

 

 

3 REPLIES 3
dougperez
12 - Quasar
tiverson
8 - Asteroid

@dougperez , what if I just focus on the assignment of account type to my data?  

How do I create thsiis?

dougperez
12 - Quasar

Just to clarify a few things:

 

How do I know that the ARE 4413 is the WC_ST account type? This have any bussiness rule?

Because you can simply transpose the Account listing by ARE  and then join the the databases

Labels
Top Solution Authors