Grouping with MSSQL Table Change Data Source
Greg Teresi asked 7 years ago
I am using MSSQL Table Change Data Source. I have data inserted into a table then I run SmartConnect to insert it for creating a Sales Order. With this setting it keep track of what is inserted. But the cell(sc_Sequence) that keep track is added by the Key Field witch screws up my grouping. And if I remove it from the Key Fields it does not keep track. What do I need to do to have my Sales Order grouped and have it keep track of the inserts?
Answers
Ethan Sorenson Staff answered 7 years ago
Hi Greg,
Lorren just posted a blog article about this topic. You will have to use two maps to be able to group your fields and track inserts.
http://www.eonesolutions.com/blog-post/use-smartconnect-change-tracking-table-data-source/
Lorren just posted a blog article about this topic. You will have to use two maps to be able to group your fields and track inserts.
http://www.eonesolutions.com/blog-post/use-smartconnect-change-tracking-table-data-source/