Ignore Dynamic Input if file is empty

[AshishAgarwal]

In my workflow one part is to Dynamic Input file (file path is based on formulae to deriv as it depends on dates).

However I have data in Dynamic Input file only on Month End and all other dates there is no file saved in folder.

There is also formulae (Multiple IF Formuale) based on file after getting data on Month End. 

So workflow throws error if file not saved.

And If I save Blank file keeping just header still formula code is throwing error.

I have read multiple post and tried if null or isempty but still not able to figure out how to proceed ahead.

Please help & advise me.

[mst3k]

can you use the directory tool to find the file and pass the value through your workflow? get the filepath from there, use a filter tool to make sure it's the right file name you want, if it's not, then no records will go to the dynamic input so it will not show an error

[AshishAgarwal]

I tried directoty toll but issue is there are many file in different date folder... Hence directory tool itself taking more time to search that file.

I kept directory run @ 11:15 IST and 20 mins has passed but still its running. Just 9% completed.

[AshishAgarwal]

Please help for above query... My workflow is failing because of above

[atcodedog05]

Hi @AshishAgarwal 

What error are you getting when you save Blank file keeping just headers. I am guessing you are facing a datatype issue 🤔.

[atcodedog05]

Hi @AshishAgarwal 

By default all the empty columns default to byte or numeric type. What you can do is use a select tool and change datatype right after input tool.

Initial:

After adding select tool.

This way most of the errors should be resolved.

If this doesnt resolve can you please snapshot of the error messages.

Hope this helps : )

[AshishAgarwal]

I am sorry but it didn't worked out.

[atcodedog05 · Accepted solution]

Hi @AshishAgarwal 

Please set Type, Book, and other string & date columns to V_String and set length to 255. And needed numeric column to numeric datatype.

Hope this helps : )

[AshishAgarwal]

Hi @atcodedog05 Thank you so much... It worked...

Very small mistake and my whole workflow was stopped.

Thank you so much for enlightening on it.

Regards,

Ashish

[atcodedog05]

Happy to help : ) @AshishAgarwal 

Cheers and have a nice day!