New to CloverDX

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

dcamarda
Posts: 1
Joined: Wed Sep 18, 2019 4:01 pm

New to CloverDX

Postby dcamarda » Wed Sep 18, 2019 4:08 pm

Hello!

I'm new to CloverDX and need some help guidance on an issue. I need to take tables from to separate csv files and output them onto a new csv file that conforms to a specific format. I have currently merged the two csv files, but in the output, values that are null do not say null. It looks more like this:

Joe|Smith||||jsmith@email.com||true|

Where there are multiple vertical bars, there should be null values in between. I also need to set parameters like if email is null, phone number is required.

Any and all assistance would be greatly appreciated!

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

Re: New to CloverDX

Postby cholastal » Fri Sep 20, 2019 7:58 am

Hi,

It is correct to output null values as empty strings because if there would be null written in the output file, it would be interpreted as a string containing value "null" when read. The null values are important only for programming/scripting languages such as CTL2. Please note that this is very simplified explanation.

Regarding your second question; when you join all the available data and certain records don't contain all the necessary information, you need to have another source of data to be able to add the required information. Basically if your data inputs don't contain the information you can't force it. Alternatively, you can discard the records that do not comply to the condition by Filter or Reformat components.

---
Lukas Cholasta
CloverCARE Support
CloverDX

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


cron