Remove duplicate bundles from google sheet search

How To
, ,
1

Hi all,

I have been struggling with what seems to be a simple task, but I’m stuck with deduplicate(), distinct(), and advanced sheets module with query language…

My data source is a Google Sheet and I am trying to search rows where the output is de-duplicated using the values of a specific column.

For example, in the sample data here: Sample_Data

There are 6 rows, where the value in column Z (leaseName) is duplicated.

The desired output is using the Google Sheets module to search the sheet and output separate bundles containing all the rows without the duplicate rows. Any of the duplicated rows can be selected (e.g the first one).

So, for the sample data, the desired output would have bundles for rows 2, 5, and 6 only

image
image1900×590 75.1 KB

Any assistance would be much appreciated!

2

Hi @Dennis_Gee

use search rows module from google sheet. And then use array aggregator.

In array aggregator, use “group by” function, and map “leaseName” in group by field. Then you directly map from array aggregator. It will only take one record for any duplicated or non-duplicated rows.

If you want to update back in google sheet, then you will need to use one more aggregator, and use update bulk rows module to update in google sheet.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

4

I was definitely overcomplicating it - thank you!

5

@Dennis_Gee Glad to know it helped you!

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation