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
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.
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