Hello,
I am trying to do a rollup that will only show unique values that appear more than 2 times. In essence, ARRAYUNIQUE(if value appears more than twice).
Anybody have any suggestions?
ARRAYUNIQUE(if value appears more than twice)
+7
Hi @Michaela_Kendall,
I’m not sure there will be a way to do this with a Rollup field, since there is no concept in the formula functions of an iterator to go through each item in the array of “values” and check how many times a particular “value” in the array occurs.
Can you explain what it is you are trying to accomplish more generally? Perhaps there is another way to achieve your ultimate goals here.
+7Hi @Michaela_Kendall,
I’m not sure there will be a way to do this with a Rollup field, since there is no concept in the formula functions of an iterator to go through each item in the array of “values” and check how many times a particular “value” in the array occurs.
Can you explain what it is you are trying to accomplish more generally? Perhaps there is another way to achieve your ultimate goals here.
Sure! I am hoping to pull info from one table into another (by means of lookup or rollup or some other means), but I only want the unique values that appear more than twice.
Courses Table
Course Name | Center (or classroom) | Disciplines
Centers Table
Center | Courses (as linked from Courses Table) | Disciplines (should pull from the Courses Table - but only those unique values that appear more than twice)
Sure! I am hoping to pull info from one table into another (by means of lookup or rollup or some other means), but I only want the unique values that appear more than twice.
Courses Table
Course Name | Center (or classroom) | Disciplines
Centers Table
Center | Courses (as linked from Courses Table) | Disciplines (should pull from the Courses Table - but only those unique values that appear more than twice)
So if a value only appears once in the list of disciplines, then you don’t want it to show at all?
+29Welcome to the Airtable community!
Do you want something like the last column in this screen capture?
This setup uses a junction table and a system of lookups, formulas, and conditional rollups.
I don’t have time to do a write-up now, but let me know if this is what you want, and I will see if I can find time to do a writeup. (Or if you want a personal walkthrough, you can book an an appointment with me from the link in my profile.)
+7So if a value only appears once in the list of disciplines, then you don’t want it to show at all?
Yes, that’s correct. I only want it to show if there are 3 or more occurrences.
+7Welcome to the Airtable community!
Do you want something like the last column in this screen capture?
This setup uses a junction table and a system of lookups, formulas, and conditional rollups.
I don’t have time to do a write-up now, but let me know if this is what you want, and I will see if I can find time to do a writeup. (Or if you want a personal walkthrough, you can book an an appointment with me from the link in my profile.)
Kuovonne, I think? It looks like it, but I am not 100% sure from the table that you show.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.