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 

[vencric]

can you pls help

[atcodedog05]

Hi @vencric 

Can you share snapshot of your workflow and issues you are facing ?

[vencric]

i'm facing the error in :has a different schema than the 1st file in the set

[atcodedog05]

Hi @vencric 

Did you try the 3rd method in this link 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

[vencric]

i'm not able to understand what they meant.. 

[atcodedog05]

Hi @vencric 

No issues download the attached workflow, change the directory path to your required path, run the workflow and check whether it's working.

Hope this helps : )

[vencric]

where can i use this one, after reading the input files ?? 

[vencric]

Thank You So much!!! i got it.its working fine... Now i have got one more requirement..... i.e, i have to write in excel stating that process is completed!!!! how can i proceed for it

[atcodedog05]

Hi @vencric 

Can you provide more info. Should completed be in a new column if yes use a formula set value as "completed" and write it. If not please provide me with more info on the requirement.

[vencric]

Yes... exactly.... something like

Ex  Program Cadence   Comments

         ABC        No           

         DEF        Yes          Completed

         GHI         Yes         Completed

          JKL        No

         MNO      Yes..          Completed