Transform
7 If the column is originating from any type of char, varchar, or nvarchar datatype column in the source, perform a transformation on the column to strip out blank spaces and | symbols, which disrupts data loads. This is done using the following commands, which should be found in any other varchar data type columns in the table.
REPLACE(REPLACE(REPLACE(idh_hist.idh_prodline,'|',' '),CHR(10),' '),CHR(13),' ')
This is placed using the Transformation tab.
8 The result is seen below. Scroll to the far right to see the transformation.
