I need to regularly import data from a supplier into Zoho to keep my records up to date. The supplier data contains a unique reference. The data will be sent to me weekly and may contain records already sent the previous week. I need to import all the new records, but discard the duplicates.

My question is therefore how do I do this? My assumption is that I need to create a new table to hold the imported data, then to run a function to compare it to the "master" table, adding new records before emptying the import table ready for next week... But I'm very new to this and don't know where to start. An answer for beginners would be appreciated.

Thanks in advance.