May 13, 2017 05:23 PM
I have a field linked to another table, and when I use roolup with ARRAYJOIN, it didn’t keep original sequences.
For example, the sequence of the linked field is [a, b, c], but the output of the roolup is “c, b, a”.
Jun 13, 2019 08:33 AM
I also need help with this exact issue. Any advice?
Jun 13, 2019 09:36 AM
What’s actually strange with this is that it’s a double-reversal: the links themselves are reversed, and the rollup then “corrects” the problem with the links.
In a test I ran recently, I made a table with these items in the primary field:
I then linked each record one by one to a control table. When looking at that table’s link field, they’re in reverse order. When using a rollup to pull data from that linked table, it reverses the order again, so they’re back the way they belong:
I suppose the point I’m trying to make is this: if you create the original links in the order that you want them in the final rollup, they’ll stay that way through this double-reversal process.