Re-Routing Data in Workflow if Column is Missing

[aMac]

Goal: Re-Route data down a different workflow path (building this in an intended Macro) if the Data source is missing a specific column ("Station"). 

If the data source is missing this expected column, it is most likely because the data source has the 'station' value hidden in another column that I used a couple tools including a Multi-Row formula tool to break out into its own column. 

However, this macro does not work or apply if the column is actually provided. I have a 'Field Info' tool that I used to get a list of all the Column Headers, but I am not sure this is the right approach-- should I think about assigning the the column headers Record Ids and somehow joining the 'Name' column as a concatenated list back as one column into the main datasource? (and then filtering the workflow from there?)

[aMac]

Goal: Re-Route data down a different workflow path (building this in an intended Macro) if the Data source is missing a specific column ("Station"). 

If the data source is missing this expected column, it is most likely because the data source has the 'station' value hidden in another column that I used a couple tools including a Multi-Row formula tool to break out into its own column. 

However, this macro does not work or apply if the column is actually provided. I have a 'Field Info' tool that I used to get a list of all the Column Headers, but I am not sure this is the right approach-- should I think about assigning the the column headers Record Ids and somehow joining the 'Name' column as a concatenated list back as one column into the main datasource? (and then filtering the workflow from there?)

[Hugo · Accepted solution]

Hi aMac,

Check out the attached workflow, it may be of some use. I've taken your idea of using the field info tool and filtering to see if there was a Field Name = "Station". I've then appended that record (which should be 1 or 0 entries long) onto the original data, and filtered by the field "Name" to see if station was a column name or not.

Hopefully this provides some inspiration

Hugo