Data360 Analyze

I have an excel sheet that I import that occasionally has fields that are null.

I cant Modify these to what is needed.

Example

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?

EDIT:

messing around, i see i can do it in a transform.. there should be a way for modify fields to ignore the Nulls... 

You can configure the Excel File node to not auto-detect the field types of the input data. This will result in all fields being output as unicode by default.

The Modify Fields node can then be configured to convert the fields to the required data types.

Note that as all the values in the From_Date field are Null, the Modify Fields node cannot determine what format is expected be present in the data it is generating an error. You can overcome this by specifying the format that would match the data values when records contain non-Null values.

ahhh nice, even though i just finished setting up a transform to force it lol

Thanks Adrian!!