Skip to content
+1-888-319-3663

COMMUNITY FORUM

Recommendation of creating additional lines as source when importing data

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

Thanks
Answers
Best Answer
Lorren answered 7 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.

http://blog.eonesolutions.com/2013/09/tech-tuesday-sales-order-import-with-gl.html

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

http://blog.eonesolutions.com/2013/12/tech-tuesday-multi-data-source-example.html



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