Transform Google Sheet Search results into a array and get difference

How To
,
1

Hi There,
I need to transform two google sheet into an array and get only the values that match in both (from a common field like “ID”).

Can you help me?

Thanks!

2

@MattiaSoragni SURE I will will like to help but first show me the setup you make already

3

Hi Emmie, I haven’t created a scenario yet because I’m not confident in using arrays :slight_smile:

4

Hi @MattiaSoragni, You can use ‘Sheet: get range’ module on first spreadsheet. Then use ‘sheet : search rows’ module, matching ID1 = ID2. third module will be an array aggregator based on search rows values.

That’s it. If we match in search rows, you’ll get results in the final array, and if there’s no match, there won’t be anything to be added to the final array. It’s fairly simple, please try it yourself first and post what are you having trouble with.