I am reading a config sheet, and based on the values present there, i'm trying to open an excel with corresponding values. pls help me
Hi @vencric without example workflow/ files it is a challenge to aide best, have you tried the Dynamic Input tool: https://help.alteryx.com/20213/designer/dynamic-input-tool
Happy solving 😄
Joe
Hi @vencric
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
You can give this blog a try. Instead of using a directory tool you can directly pass the filenames.
Hope this helps : )
Thanks @JOEHERBERT . Actually, in a config sheet i'll have two columns named Program and CAdence .
Ex Program Cadence
ABC No
DEF Yes
So, I have to to open an excel file named DEF.xlsx
Hi @vencric I think you could use iput tool pointing to the config, then a filter to bring back Cadence= Yes, then a dynamic input to bring back the relevant file paths and open up:
Does this help?
Joe
Like..
Ex Program Cadence
ABC No
DEF Yes
GHI Yes
JKL No
MNO Yes..
So, i have to open DEF.xlsx, process and compute and store the output, then select GHI, then MNO like that..
Hi @vencric
You can do something like below.
Workflow:
Please refer to blog 2nd method to get a better understanding https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...
Hope this helps : )
Hi atcodedog05.. Thanks for the solution...I'm able to proceed but getting below error : has a different schema than the 1st file.. But all files are having same columns and datatypes
Hi @vencric
This issue occurs even if when there is a slight formatting issue. Please refer to blog 3rd method and adapt for your usecase it should work
i'm not able to do it.. 😞