Using Text Input to Dynamically read input and manipulate data

Hi Alteryx,

I am stuck and not able to dynamically read an excel file and manipulate the data.....

Basically I have excel spread sheets saved in a shared drive where the name is in a generic format eg name + date. I would like the user to be able to enter the date so that the Dynamic Input tool will read the respective spreadsheet and then manipulate the data from there.

I was able to read the spread sheet but it comes up under another browser instead of the Dynamic Input in the work flow which would mean I won't be able to add in any filtering etc after the Dynamic Input tool..

Any solutions to this?

Also does Alteryx store the entered value so that I can call the value anywhere in the workflow and if so how do I do this?

Test Trades.yxwz

Input

Interface Tools

Accepted answers

Jax23

Thanks Mark. There where some good information in your video however it doesn't solve my problem. Cheers Jax

All comments

MarqueeCrew

Here's a video that might help you:

https://youtu.be/k5cVUa0Oq70

Cheers,

Mark

Jax23

Thanks Mark. There where some good information in your video however it doesn't solve my problem. Cheers Jax

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703