Skip to main content
September 15, 2023
Question

null values are stored as empty strings in the Appian cloud database while using the plugin to import Excel to a database in Appian

  • September 15, 2023
  • 1 reply
  • 0 views

Hi All

I am using the plugin to import Excel to a database in Appian while importing data in to appian cloud database the null values are stored as empty strings.

Many Thanks in advance

1 reply

mathieud0001
September 15, 2023

I would assume that perhaps the plugin just works this way.

Could you just not run some update statements after the import to update any fields with empty strings to NULL?