Hadling error if there are no file on folder

[Felipereis50]

Hi friend’s
There’s a way to pass an error if the node not find a file?

Explanation

I have a flow that uses a “concatenation” (print 1) , but on the second flow, there is no file inside the folder to lookup. (print 2)

But, the missing file is not an error, is because for the situation, it will not exist.
What I want is to do something that passes the error, even if there’s no file found.
The result is that the “concatenation” will not concatenate nothing on second flow.

Print 1

Print 2

I’ts possible?
Because if not, I will have to put any file into the folder (dummy file, only with header and not content)

[takbb]

Hi @Felipereis50 take a look at this post I did earlier today, which attempts to read a csv file and handles it if it doesn’t exist.

Adding date to the running table based on Workflow

Hi @umutcankurt , presumably your reference table will be stored as a file so that on each invocation it reads the file and appends a new “yesterday” date, if it isn’t already present? I’m not sure if this is entirely what you had in mind but I’ve bundled a small workflow into a metanode, so that it acts like a simple table. When it executes it finds yesterday’s date and appends it to the end of a csv file stored in the workflow’s data area, and returns the current date table in full. The addi…

[gonhaddock]

Hello @Felipereis50
It isn’t clear for me that your WF starts with a ‘List Files/Folders’ node in the sketch, and the Excel Reader misses the file four nodes afterwards…

You can join the target path vs the reading from the List Files/Folders, then you can use an ‘Empty Table Switch’ node. In this way you get a parallel flow. The Excel reader has to be allocated in the upper flow; the lower is the alternative… you can read a template empty dummy (in the alternative workflow); or if the first file does always exist, you can connect to an empty filter from it. These two EndIF workflows converge within an ‘End If’ node…

This is the idea…

Let me know about your thoughts

BR

P.S. The Sketched image is representing the empty returning of an error control from R Script, whenever there aren’t any error descriptions so the lower workflow is an empty, returns an alternative table

[gonhaddock]

Hi @takbb
You are like a live nodes’ encyclopedia, nice solution in that post . I always find basic solutions with the yellow ones; reading your posts gives me insights for next challenges.

BR

[Felipereis50]

Thank you very much friend.
I will definitely look at your post.

[Felipereis50]

Thank you very much friend, for the support.

I’ll learn a lot with you guys.

[takbb]

Kind of you as always @gonhaddock , but my workflows are also generally a sea of yellow, and even then it’s amazing how many yellow nodes I have no idea about!