convert string to whole number using magic etl
I am trying to convert the datatype of a column to whole number which is having a string datatype using magic ETL and getting attached error. Source for the data load is from CSV file and i am loading data using workbench. Also tried changing the datatype in workbench which also could not complete the run.
And when tried converting using Magic ETL getting attached error.
Error : Failed to convert data ' ' to type integer for column "Name of the column"