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.

Transformation

Preparation

Accepted answers

atcodedog05

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

All comments

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

Empty File.yxmd

AshishAgarwal

I am sorry but it didn't worked out.

atcodedog05

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703