I have an excel sheet that I import that occasionally has fields that are null.
I cant Modify these to what is needed.
From_Date on the sheet is null.
I tried importing as is, so excel sets it to unicode, but in the modify fields, I cant change it to a date
i tried default as string, same issue, modify says its set to date, but analysis says it should be unicode...
this happens for a number of the fields randomly because the import file changes.
Can i set field types in the spec?
is there a way to make the modify field ignore this error?
messing around, i see i can do it in a transform.. there should be a way for modify fields to ignore the Nulls...
Please sign in to leave a comment.