How to alter a column in text and cast data type as integer?
How to alter a column that is in text and cast data type as integer or floating decimal? I get this error when using the Alter Columns tile: 'Failed to parse text ' ' from column 'Column A' as type 'Integer' How can I alter the columns data type in the magic ETL successfully?