Forum Discussion
Error: DataFormat.Error: We couldn't convert to Number. Details: #N/A
When I am trying to expand the column after merging two tables that have a common column and the same data type, I recieve the following error.
Jimmy801
Community Champion
Community ChampionHello Ishi_garg
most probably you forced column type change into number to do the merge, but not all of your data were numbers, and so somewhere in these columns you have a converting error. When you then merge queries with a column that contains that error, you will get this message
Jimmy