Handle field names with special characters

Overview

In Etlworks, you can configure source format to transform field names with special characters into SQL-compatible names.

Example

Fields in the source (for example, JSON or XML response from a call to the web service) contain special characters that are not compatible with SQL. As a result, these fields cannot be used in SQL.

[
   {"m:first": "Joe", "m:last": "Doe"},
   ...
]

Process

When configuring CSV, JSON, XML, or a Fixed text Format, tick the box beside Column names compatible with SQL to set it to yes. Etlworks will convert the column names to SQL-compatible column names by removing all characters that aren't alphanumeric or spaces.