How can I influence the order, in which the LOOP COLLECTION Operator works
Hi there,
I have a process, where I get some data from a database for the last 7 days for up to 20 different machines.
In a second step, I want to do some aggregations and reports for each of the included equipments. This works pretty straight forward with the LOOP INTO COLLECTION and LOOP COLLECTIONS Operator. But the problem is, that the LOOP COLLECTIONS Operator does this in a (random) order, e.g. starts with machine1, than machine3, equipment 5, machine10, machine6, ...
But I want to influence the order, e.g. by increasing names of the machines, to have it in defined order for each run.
Any suggestions? Tried of course , e.g. sorting before grouping, but with no success
Thanks in advance!