New Netsuite connector - Merge Not Working
The Netsuite connector now has a feature to 'Merge' (UPSERT) records from a saved search and you get to identify the primary key of the record (to check if it exists).
Since there was no information I could find about the 'Remove Duplicate' records feature (ie: What does Domo check to figure out what is a duplicate?). For example, I had a bad cost on an invoice, I fixed it and since I changed it (last modified date) it was going to be uploaded again. Is that going to replace the "bad" invoice in Domo?
So I had throught the 'Merge' was going to save the day by updating the bad record with the new "fixed" one (with the same unique key field).
Bzzzt ... Wrong Answer.
I changed my connector to use 'Merge' (vs Replace or Append) and if failed. No error message other than 'It failed.. try again' (Of course I did that... a few times).
Hey Domo, do you read these forums, any insite on this.
(btw: New to Domo but not new to Data Whse and ETL / SQL concepts)