How to Fix the Issue of SmartConnect Processing Source Data in an Unexpected Order

This video will address the problem of SmartConnect processing source data in an unexpected order. This issue likely comes from how SmartConnect handles Key Fields. Even if you select fields like STATE > CITY > CUSTNMBR, SmartConnect may sort them differently due to how it stores field order using random GUIDs. This video shows how to check the actual processing order with a SQL query and how to update it manually to ensure your data is processed in the correct order. Perfect for users of SmartConnect.com, SmartConnect 21, or 2018.

If you'd like to read the documentation that goes with this, click here.