Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
This expression seems to be incorrect as the load script aborts with "invalid expression":
Count(DISTINCT [Order Number]) as [Count Order],
Any ideas how to fix this?
Thanks for your help
Tom
You need a group by statement for each field which isn't included within an aggregation.
- Marcus