Ignoring empty cells rather than overwritting- Excel importer
0
Hi, I am trying to import data and some of the cells can contains empty. In that case i want to ignore those cells rather than overwritting the attributes with empty values. I tried going through the settings and only find ignore empty keys. So is there any option to ignore empty cells?. Thanks in advance
asked
Thmanampudi Lokesh Parameswara Reddy
1 answers
0
One way you could do this is to read the Excel file into a holding table and then create a microflow that writes the data to your production table in the way you want. This would allow you to do some pre-processing, check for nulls, etc.