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.

Lookup value based on separate input

tiverson
8 - Asteroid

I have template file that wants to populate an amount based on date and need to lookup the values from another input, however the date criteria comes from another input.  

 

First text input has data

tiverson_0-1643925357025.png

Second input has the blank template where values need to be added

tiverson_1-1643925394649.png

Third text input that will be entered and determines what column and line the amounts will fall on the Second input

tiverson_2-1643925422588.png

This workflow will be used daily, so that is why I need the flexibility to enter the current data for looking up values

 

This is the output I am looking for

tiverson_0-1643925748073.png

 

Thanks,

Todd

 

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@tiverson 
I hope this is what you need.

0203-tiverson.PNG

Labels
Top Solution Authors