- The Message value for the first row of data contains carriage returns, which must be captured in the data value and not used to split the row.
- The Message value for
thughesis a single unquoted value.
When the data is first loaded into the Transformer page, the following step is added as the first step to the recipe:
This transformation splits the unstructured CSV data on the carriage return. However, values that are stored between double quotes are treated as single strings, and no row breaks are applied to this data.