excel data source shows blank lines
but we cannot use the ODBC when using the Folder Data Source.
How can we get the Excel data source to ignore the blanks while still using the folder datasource?
On the Options tab of the map, you can switch the option If there are blank lines in the data Source: to Exclude Blank Keys or Exclude Blank Lines.
Hi Lorren – I just tried this fix, but it did not work for me. I believe this is because my underlying Excel source file actually has some formulas that are returning many rows with nothing but blanks (“”). Here’s an example of my formula, which I’m guessing Smart Connect is not recognizing as “true” blank cells or “null” cells:
=IF(ISBLANK(‘Pmt Manager GL Extract Run’!BF2),””,’Pmt Manager GL Extract Run’!BF2)
Any way to get around this using the straight Excel 2013 connection, and not having to go thru an ODBC connection with a limiting query?
Smart Connect Version 188.8.131.52
Dynamics GP 2016
If you would like to submit an answer or comment, please sign in to the eOne portal.