SAC Model - Keep empty date field

[axel_]

Hello SAC Experts,

currently working on the first SAC prototype. When I import my flat file data it is complaining that for a date field there are blanks.

However, that the date field is not filled for all records is totally valid. So how do I trick data validation to ignore so that I can actually create the model? I tried to assign # for blanks but data validation is also complaining about this.

Any ideas?

Thanks and best regards,

Axel

[former_member56890 · Accepted solution]

find the attached screenshotsscreenshot1.jpgscreenshot2.jpgscreenshot3.jpgscreenshot4.jpgscreenshot5.jpg and follow those steps