Skip to content
+1-888-319-3663

COMMUNITY FORUM

Ignoring Rows and Columns

john.ellis@tribridge.com asked 8 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 8 years ago

John,

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.

Lorren

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

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