Hello, I have a workflow that reads in two data sources, joins them, and transforms them. One data source, read in using a CSV Reader, is only available at certain times of the year. Is it possible to use the Java IF Switch to determine the status of that CSV Reader node, and if the node is idle (no file path because the file is not available), to route the data through the switch to a Constant Value Column instead. Attached is a mock up of what I would like to accomplish.
I am currently using a manuaul IF Switch, but I'd like to automate the process if possible.
Thanks,
-Nathan