Append data issue using CSV upload
Hi All,
I'm uploading CSV file via workbench and I have scheduled every four hours. I'm getting all the records without any update. My requirement is to get all the records which are not present and which are present those records to be updated. But, what is happening is records which are present are not updating but adding an additional row. Please help with this. Thanks
Comments
-
Arav,
It sounds like what you need to do is run your file through a dataflow to remove duplicate rows every time it is uploaded and/or perhaps do a mysql transformation to tell it to keep only the most recent records in cases where there has been an update.
I hope that helps!
0 -
Hi User,
Thanks for the reply. Is there a way to use merge while uploading CSV file in the workbench. So, that it can search for already existing records and replace with new records. Also, using your solution, may I know exactly what is the process to follow?? Thanks.
0 -
I am not sure I understand what your are trying to do. Does the CSV file uploaded every 4 hours contain all records since the beggining of time or is there new data evety 4 hours? If you can elaborate I might be able to give you a simpler solution than below.
Use the info in the thread below to generate an appeding CSV dataset that will delete all duplicated rows
0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有