Forum Discussion
Merge 2 tables: Error DataFormat.Error: We couldn't convert to Number. Details: NA
Hi, my best guess is that there is some value, that is messing up the transformation.
Both columns should be possible to transform to text. I cannot imagine a scenario, when not. As for transforming it to a number, there could be some non-numerical symbol, that doesn't allow the transformation (and in the case of text it won't fit the merge.
Right now it is difficult to say. Send some sample data, if the transformation to text doesnt work..
Hi, my best guess is that there is some value, that is messing up the transformation.
Both columns should be possible to transform to text. I cannot imagine a scenario, when not. As for transforming it to a number, there could be some non-numerical symbol, that doesn't allow the transformation (and in the case of text it won't fit the merge.
Right now it is difficult to say. Send some sample data, if the transformation to text doesnt work..
You were right. The original data has at the end of the rows, some note showing information of the downloaded data. It wasnt part of the data, just a note of the file. Remove it and all goes well. Thanks!