I am using the email connector to send .xls files to DOMO. There were some fields in the excel file that contained "#N/A" and they were automatically converted to "ERROR 42" in the dataset that was created and caused my downstream dataflow to fail.
Is there a way to have the connector somehow ignore #N/A fields or convert them to NULL instead of "ERROR 42" ?
Appreciate any advise anybody can provide.