Skip to content


Recommendation of creating additional lines as source when importing data

oscar87 asked 8 years ago
Need some recommendation of how to add additional lines of data part of the source data?

1. Put the source file into a staging table. Execute different business rules through an external application i.e. C# and store data into a new table and then use SmartConnect to integrate data into GP?

Your Guidance will be appreciated. 

Best Answer
Lorren answered 8 years ago
You can use this blog article as an example of generating additional lines by using the ODBC Connection and using the Union statement in your SQL Query.

or you can use a multi-data source to link the data together.

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