Hi all,
I want to set up a filter that only passes data from Google Sheets if the entry is not duplicated. I think the way to do this is using the row number, but don’t exactly know how…
Input:
I have a Google Sheets spreadsheet containing information of various leases (I’m working for a Property Management company). Unfortunately, the lease information is duplicated if there is more than one tenant on the lease - only the tenant details are different
Here’s some Sample Data
To get the data into Make I’m using the Google Sheets module - Search Rows with various filters (startDate, endDate, status etc). I get the lease information I want, but it returns all three rows as individual bundles
What I want to do is only return data from a single row irrespective of whether other lines with the same leaseID exists in the sheet. I thought that maybe one way would be to set up a Make filter after the Sheets module that uses the row number value and only passes through a row number with the lowest value and discards all the others (if they exist at all).
Here’s my starting point - can someone please advise the best way to do this? Thanks in advance!
Scenario.txt (34.9 KB)