Importing data from Looker and keeping the latest entry per key

Hey folks!

I’ve set up an export of records from Looker to Airtable. The view that I’m exporting may contain duplicates of previously exported rows, and I’d like to set up a view that contains only the latest exported entry per each key, where key is a single column. I’ve set up a CREATED_TIME() and RECORD_ID() columns and tried keeping the latest entry using links, but as far as I can see links need to be manually added which is completely unfeasible and kind of ruins the purpose of automation of the whole process.

How can this be done? I’m open to having to write code, use existing blocks, or similar.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.