Zero Record DateTime

CSmith16

Hello,

I am running into an issue. We have data that is downloaded and imported through a dynamic input tool. We sometimes upload blank data (literally blank, no column names) for days that have no activity. Problem I'm running into is the workflow errors because tools reference column names that aren't present. I can filter the data to only give data that has a record count greater than 0 but that doesnt fix the DateTime tools that are missing a column.

apathetichell

create a 0 record text input tool with your needed schema (ie column names). Union it to your data stream. this will mandate that the column names are there at run time.