Forum Discussion
Dataformat error: we couldn't convert to Number issue
SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it
SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it
amitchandak you were right. i took all the steps which i have performed on the data and its look like,
at first the ID column which was in Text format - i have changed it to Numeric and later on i rechanged it agian to Text format.
by removing the wrong step : which is changing the format to numeric, i was able to resolve the issue.
I could say its an Human error but accept your suggestion as a solution for my question.
Thanks again !!