If you require to rename buffer fields that contains special characters, please follow the instructions below:
Illustrated in the image below is an example of a flow that reads an Excel spreadsheet, fixes the invalid field names containing special characters in the buffer using the Buffer Fix mapper step and then upserts the data to a buffer.
The data that is returned from the Excel reader step is in the below page. The dollar sign ($) is used as a special character in front of the fields.
The Buffer Fix mapper step is used to replace a buffer’s field names that contain special characters with what is specified in the step configuration as shown in the below image. The default character is a hyphen (-), including if the field is left blank.
N.B: The Buffer Fix mapper step will only replace the special characters in a field name in the buffer if they all have the same special character. If different special characters are used in the field names, then add Multiple Buffer Fix steps to replace each special character.
Illustrated in the below page is the output of the buffer field names where the dollar sign ($) is replaced with an underscore (_).
