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 

[atcodedog05]

Hi @vencric 

You can use IF formula like below.

Workflow:

Hope this helps : )

[vencric]

but i can do it , only if the programs were run successfully .. what if it got failed... Also now i'm getting an error

[vencric]

Hi atcodedog05, Actually is it possible to store the variable from an excel and pass it as parameter
Like.  Program CAdence Value

           ABC         Yes        GHI  

I have to pass "GHI" to another workflow as a parameter... pls let me know.. Thanks

[vencric]

Can you pls help on this

[vencric]

hi @atcodedog05 , is it possible to trigger the, Alteryx workflow using PEGA Openspan tool...any idea on how to trigger it for RPA purpose

[atcodedog05]

Hi @vencric 

As far as I know, I don't think you can trigger Alteryx workflow from other applications.

[vencric]

Thanks @atcodedog05 .. Regarding the comments to be updated as completed successfully i can use IIF Command , but  , only if the programs were run successfully .. what if it got failed

[atcodedog05]

Hi @vencric 

If all were successful then the workflow will not throw error is not successful then the workflow will throw error has you experienced previously.

[vencric]

Got it!!! but how to capture those errors alone ?

[vencric]

hi @atcodedog05  how to use excel files from Sharepoint