Make Cell Splitter robust when input column is empty (Excel sheets with optional data)
I I process a monthly Excel. Sometimes the column has values like
20649862_21.05.2015_-31279713_7603063which I split with Cell Splitter on
_. Other times the entire column is empty. When it’s empty, Cell Splitter fails (can’t “guess” the number of output columns) and the workflow stops.
Goal: The workflow should continue even when the column is empty—ideally passing a 0-row table with the same post-split schema downstream.
Question: What’s the best practice? Thank you