How to Open an excel with values being given dynamically , referring an other excel sheet

[vencric]

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 

[JoeHerbert]

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

[atcodedog05]

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.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Hope this helps : )

[vencric]

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

[JoeHerbert]

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 

[vencric]

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..

[atcodedog05]

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 : )

[vencric]

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

[atcodedog05]

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

 https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t... 

[vencric]

i'm not able to do it.. 😞