Extract the last x records updated each days

[PACAP]

Hi

Each day a google sheet datasource is updated with the data of the day

From this table I would like to update my report only with the last 365 records from this table

Thx 

[ArkadyZagdan]

@PACAP 
Doable but you need to push data into BigQuery and use some smart INSERT or MERGE INTO with WHERE clause appending or replacing only data you nneed.

Arkady Zagdan - Bigglo

[PACAP]

Hi @ArkadyZagdan

Doable from the free or sandbox versio, ? Could u tell me a little bit more On How ?

Thx

[PACAP · Accepted solution]

Or easier with this formula in google sheets : =QUERY(DATA;"SELECT A, L order by A desc LIMIT 365")

[ArkadyZagdan]

@PACAP If that field is insert time or an progressing ID then yeah Query would do the work.