How can I import data from SQL using an import scenario with an Order By clause? Or what work arounds have you come up with?
Most situations I’ve just made sure the data is in SQL in the order I want it, but sometimes that’s a challenge with complex views.
The issue is it creates conflicts where there are many detailed rows but the data is not in order. Setting Save to Each row or Batch size to 1 doesn’t help either.
The help documentation specifically says Order By cannot be used in the command fiels, so I’m guessing this is a common issue.
Best answer by bryanb39
View original