Automatically strip leading/trailing spaces from incoming values/source files
Please bring back Omatic Cloud automatically stripping leading/trailing spaces from incoming values. The previous version of Omatic Cloud did this and the new version does NOT do this which means any data differences have to be accepted one by one. The only other alternative is adding a transformation to remove the spaces. However, it is not possible to specify leading/trailing spaces so this is problematic for many incoming names!
In today's release, we have added functionality to automatically remove leading and trailing spaces on ingestion. In addition, you will have an option during routing to count/ignore spaces in the destination as a data difference. Spaces will be indicated in the grids with a purple box surrounding the space.
Let us know what you think or if you have any questions after the release!
Best,
Kristen Gajdica
Senior Product Manager