Question

Handle missing values Excel

1

Hi, How can I handle missing values in an Excel document if I want to import it using ExcelImporter? Leaving the field blank does not import all the rows, and replacing the blanks with ‘?’ throws an error since it expects a different attribute type. Any suggestions?

asked 2021-07-15

Ibai Franco

1 answers

Jean Nascimento · Accepted Answer · 2021-07-15

An alternative to resolve these whites values in a import is handle this values in a microflow before. When you import data you can call a microflow and then in loop for you can check if the attribute value is empty. then in a conditionally you dicide what you do.