Thanks John - you and I may be pointing in the same direction.
Does anyone else in the community know how to push the row limit down to the SQL server, instead of just truncating at the client? I have profiled this using SQL profiler, so I can see that the row limitation is not being sent to the SQL server currently (unless you explicitly write your query as "Select top(xx) * from Table", but given that there is a row limiter, this is probably not something that most users would think to do.
If this doesn't exist in any way, then I'll log this as an idea.
I'm not sure, but you might get directed to the In-DB tools for this. Along those lines, possibly my single biggest "want" is for automatic push-down optimization, along with which would come obsolescence of the In-DB tools. Despite my desire for this, my "idea" logged a while back gained zero traction, LOL: Automatic Pushdown Optimization. I perhaps could have worded it better. (Actually - looks like mine is basically a duplicate of this one. Oops.)
@watsacha It sounds like you are using the legacy scheduler (as opposed to the new gallery scheduling that can be enabled in an 11.0 private Alteryx server). In that case, you would indeed need to delete the old schedule and schedule a new one with your updated flow. Let me know if you are using a private Alteryx server and want different options for getting around this inconvenience.
Are you using the Win10 machine as a Server?
I understand the concept and can confirm it works: you can install Alteryx Server on Win10 and use it as a Server. Other machines will be able to communicate with it, just like a server.
But the more serious question is the one @MarqueeCrew pointed out - why would you want to?
If you're going to spend the amount of money that it costs for a Server license, you should really do it right and put it on an actual server.
I've been down this path before and ultimately it isn't worth it to put Server on a Desktop (unless just for testing). The point of having Server is having the stability that comes with a server (usually maintained on power backup, snapshots in case of failure/corruption, stable OS, etc).
There's no capability in the Summarize tool to carry non-summarized rows through - the reason being that when you summarize it reduces the row count and the other rows may be at a different granularity. So you have to re-join this data after the summarize back to the original data if you want to re-constitute, or else include these fields in the summarize.
If I summarize this data by type and weight, I could get 2 rows with the average weight for Dogs & Cats. (which is what I would want)
However, if I tried to pass through colour then you have 4 rows again (because there are 4 distinct values in Colour)
Now - you do have a way to bring Colour, but as a summarised list as follows
You can do this using one of the string Concatenate operations in summarize..
Let me know if this helps to answer your question? If not, perhaps we can work together with some sample data to get you to a result that works.
thanks @becki, have a good weekend
Scratch my first response. Looking at @Joe_Mako response and then re-reading your original question, I think this might be the combination you're looking for - a parse though, not a match, and for it to pull out just the string of 8 digits from the larger string regardless of their location in the string. Getting closer? :)