How add new records to a dataset

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

lkaiser
Posts: 1
Joined: Wed Jun 13, 2018 9:27 pm

How add new records to a dataset

Postby lkaiser » Wed Jun 13, 2018 9:38 pm

Hi evreryone,

I just testing the product and I want to know how to append "manually" some records to a dataset.

I put an UniversalDataReader connected to a CSV file, a Reformat and a SpreadSheetWriter, and all works fine.
The CSV file contains 1000 records (physical adresses) and tha SpreadSheet has to contain 1002 records (1000 + 2 adresses of my colleagues).
How to script this ?

Thank You in advance

PS : sorry for my english

cholastal
Posts: 134
Joined: Tue Sep 01, 2015 1:22 pm

Re: How add new records to a dataset

Postby cholastal » Tue Jun 19, 2018 1:57 pm

Hi,

This kind of task can be done fairly easily using a component called Simple Gather. You can connect both data sources to its input ports and it will append the data from one source to the other creating a single dataset. Attached is an example graph with some example data.

If this is not what you were asking for or if you have any other questions, please let me know.

Best regards,
Attachments
gather-example.zip
(2.04 KiB) Downloaded 76 times

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron