Sort stage Warnings

[larryoceanview]

Any way to turn warnings off from a sort stage into a transform?

Code: Select all

Sort_10: At row 1, link "DSLink24", while processing column "FUBAR"
Value treated as NULL
Attempt to convert String value "" to Long type unsuccessful

Thanks,

[chulett]

Only way to "turn them off" is to ensure they don't occur. Looks like you have an "empty" field that is being moved into a Long datatype and it doesn't like that. Can you check for and transform that to something else before the Sort stage, like to a NULL or a Zero perhaps?

[larryoceanview]

Only way to "turn them off" is to ensure they don't occur. Looks like you have an "empty" field that is being moved into a Long datatype and it doesn't like that. Can you check for and transform that to something else before the Sort stage, like to a NULL or a Zero perhaps?

If time permits, but I have about 50 different fields with similiar errors and some have valid data. I just wanted to supress the warning like in the file stages. Shouldn't the sort stage be consistent with the file stages?

Thanks,

[chulett]

What "file stages" are you referring to that allow you to suppress fundamental data type mismatch warnings like this?

[larryoceanview]

What "file stages" are you referring to that allow you to suppress fundamental data type mismatch warnings like this?

Format sequential file stage- suppress row truncation warnings!

[mandyli]

Please handle null values.


Thanks
Man

[gh_amitava]

Hi,

Set the "Nullability" of the field to "Yes"

Regards
Amitava