Skip to content


Ignoring Rows and Columns asked 9 years ago
What sort of scripting can I place in a SmartConnect map to tell it to ignore unnecessary row at the top of the source file spreadsheet and unnecessary columns to the left of the data in the spreadsheet?
Lorren replied 9 years ago


What is your datasource?  The best option would be to set up the datasource as an ODBC Connection and then write SQL against that data source to restrict rows based on specific criteria.  This also allow you to eliminate the columns you don't want to see for creating your mapping.


Best Answer
johnellis answered 9 years ago
Good idea!  Thanks, Lorren!

If you would like to submit an answer or comment, please sign in to the eOne portal.