Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.

SAINT setting to treat empty cells as empty

Avatar

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

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

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

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

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".