Help

ARRAYJOIN didn't keep reference type order

Topic Labels: Formulas
2115 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Johnny_Kao
4 - Data Explorer
4 - Data Explorer

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”.

2 Replies 2
Anonymous
Not applicable

I also need help with this exact issue. Any advice?

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:

31%20AM

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:

Screen Shot 2019-06-13 at 11.29.43 AM.png

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.