Help

Re: How to join multiple rollups into one big array with only unique items?

Solved
Jump to Solution
580 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I'm using my airtable to attached keywords images. 

I have one big keywords table with multiple categories of different keywords. Then i have multiple linked columns to the different categories. However some of the keywords overlap into different categories.

So I thought I could rollup all my linked columns and do something like this:

 

 

ARRAYUNIQUE(ARRAYJOIN(ARRAYJOIN({RollUp1}) & IF({RollUp2}, ',' & ARRAYJOIN({RollUp2})) & IF({RollUp3}, ',' & ARRAYJOIN({RollUp3}))))

 

However I still have duplicates of keywords in my final array. Does anyone know how I can join my rollups and then filter out all the duplicates?

 

10 Replies 10

@Kim_Trager1 Cool, check out my video that I linked to above. It's not a complete training session on using arrays in Make, but it does give some valuable insights into arrays.