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.
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…
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
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.
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!