Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
Register Here

SAINT setting to treat empty cells as empty

Avatar

adierl
Level 10

12/9/12

Would be good to have a setting for SAINT import to treat empty cells as empty and not as "keep old value". Currently you have to overwrite empty strings with "~empty~" to delete values.

5 Comments

Avatar

nic_cm
Level 5

12/10/12

I do like it the way it is, although I see benefits in the motion.

 

This should definitely be an option instead of a default setting. I see all sort of legacy processes tied to the current behaviour with lots of SC clients.

Avatar

benjamingaines2
Employee

12/12/12

My concern with this is simply that things might get overwritten a LOT. But it's a good idea and something I'll pass along to the SAINT development team. Keep the comments coming!

Avatar

adamhaining
Level 5

12/12/12

Yeah I like this one, but maybe have it be a setting that the user can turn on (not something that has to be done by Client Care).

Avatar

jmborange
Level 1

3/18/13

At least there is a workaround with the ~empty~ value. The bigger problem is if you are submitting a value of "0". This will be regarded as "NULL" instead of "0".

Reply