How can we help you today? How can we help you today?

CSV import and null values

We have a CSV file that get's imported where the last column in the bunch of NULL for all entries.

When we import this, all other entries get mapped to a real NULL except that last column, which is always set to the string "NULL". Is there a way around this?

Edit: Actually, it appears that this is the issue when the type of the column is nvarchar. It will always put in the string value "NULL" instead of NULL.
i8beef
0

Comments

1 comment

Sort by
  • Manfred.Castro
    Thank you for reporting this issue to us.
    I was able to reproduce the reported behavior and have logged it under the internal reference number of SDG-1047
    As a workaround if all values in the column are null you can use a regexp generator for the column and just set the allow null values percentage to %100
    Manfred.Castro
    0

Add comment

Please sign in to leave a comment.