Type conversion with Transformation Flow
When we import data from Excel (export to CSV) with itemnumbers inside we have a problem converting them. If we have a leading 0 we have to put in a line with text and ignore that line, otherwise it will be numeric. When the metadata says its text and we remove that line, it produces an error because the metadata is not correct.
Why can't we just specify each column type during the import step? Or is there a way to force this?