Forum Discussion

MilapM's avatar
MilapM
Icon for Helper I rankHelper I
5 years ago
Solved

How to deal with errors in a column after import.

I have an excel workbook and a region sheet within. After I import the table, I am getting errors for various cells of the postal code column in the region table.  As you can see, I am g...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    The column has a numeric data type or a conversion to that type.  Change it to text or remove the conversion step

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

The column has a numeric data type or a conversion to that type.  Change it to text or remove the conversion step

  • MilapM's avatar
    MilapM
    Icon for Helper I rankHelper I
    5 years ago

    Changing wasn't doing any difference so I had to remove the conversion (changed type) and then manually select data types for each column as removing the conversion types resets the data types to Unknown.
    Thanks.