I’m attempting to read a data table in from an excel sheet, and read a particular column to detect any blank criteria. When these blank rows in the DT are detected, i then need to populate a column to the right of the blank rows with text information.
Refering to the example below, i’ve provided a visual example of what i need to happen. I’ve already used a read range activity to bring the entire target excel sheet in as a data table, now i’m attempting to filter it. But it won’t work at the minute.
Any help would be greatly appreciated!