Skip to main content
yogeshc213832
Known Participant
Sep 15, 2023 7:15 AM UTC
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

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
mathieud0001
Genius
Sep 15, 2023 7:22 AM UTC

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?

Terms & ConditionsAccessibility statement