Hi -
The workflow attached is for a macro that identifies whether the current column header set has either null/blank value which would be labeled as F1, F2, F3, etc and moves on to the next row to see if all values are not null/blank in order to use that row as headers. How can I make sure that the macro is only used when the column headers contain F1, F2, F3? I'd like there to be a section where the data does not need to flow through the macro but I've tried a filter with true/falses which causes both true/false streams to run as a union tool is used to pull the input data even if the stream has 0 records.
To sum it up: how can I set up a workflow with this macro to ensure data is passed through only if it meets criteria ELSE do not change the header.
Thank you - I'm open to all thoughts and ideas on how this is normally handled since I have the same issue with using my other macros!
