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!
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!
-
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.
Please sign in to leave a comment.
Comments 1