Skip to content


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

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