I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB.
Is this an expected behavior of this smart service?
Is there any way to import or read a csv file with null values?
Discussion posts and replies are publicly visible
Are the null values separated by your defined delimiter?
Yes, the null values are separated by the delimiter