Trim all fields in Data Mapper

[ankushdeshpande]

HI All,

I am exploring TDM and need some help. I want to use trim function available in data mapper functions to be used for all the input fields. input/output is json. is there any way to drag and drop Trim function on Root element and apply trimming to all columns?

[Anonymous]

Hello,

Here is a Flat representation property "Trim whitespace on input". When you select this checkbox, any leading or trailing whitespace is removed automatically from the input data for all elements. The non-leading or trailing whitespace is not affected.

For more information, please have a look at this documentation:https://help.talend.com/reader/qtCMQC4G~aT_JOjfVUem9w/HMURjUOXJmrXJ54DGzFcPw 

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina