Upload Tool and UPDATE query with condition for .CSV
Dear team,
We want to use the
Upload Tool to update a table in
Zoho Reports. The source of the data is a .CSV file which is going to be generated by a third party application. This .CSV file will contain the entire database.
When uploading the file in Zoho Reports, we would like to UPDATE the records based on a column with last modification (timestamp). We therefore would like to have something similar to a
WHERE condition to select the appropriate records.
This .CSV is quite heavy and we would like to avoid having to manually select the records.
Could you please advise how should we proceed?
Many thanks in advance!
Best regards,