Discussions
-
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?
-
How can I find rows in one column that are not in another column
I am using a magic ETL. I have tried using a left join but it returns the rows that are not in the other column and also all the left column rows.
