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.
Thanks
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 8 years ago
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.
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
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