Select some record field

CloverDX Platform
1

Hello,

I’am a beginner with cloverETL, and as evaluation, I wanted to try some simple exemple.

This is my first problem : I have a csv file, say InputFile.csv. In that file, the lines have this format :

8<-----------------
field1;field2;field3;field4
8<-----------------

And I want to copy this file to OutputFile.csv but without the third field :

8<-----------------
field1;field2;field4
8<-----------------

I thougth than some standard component could solve this problem, so I search in doc and components Java API, but I didn’t find anything.

So I think I could use some kind of Reformat component, could I ?
If this is the solution, which metadata have I to put, on which edge ?
Is it something like that :
8<-----------------

















8<-----------------

Any help is appreciated.
Thanks in advance (and excuse me for my ugly english)

Francois

2

I tried something like that. In fact it was my first idea of what is a metadata and how I can use it, but the process stop after the first line… I will have another look at my xml to see where is my error.

Many thanks for your help,

François

3

Hello!

In one minute i prepared in Clover.GUI easy schema for your purpose.

<?xml version="1.0" encoding="UTF-8"?> ${out.0.Field1} = ${in.0.Field1}; ${out.0.Field2} = ${in.0.Field2}; ${out.0.Field4} = ${in.0.Field4};

If you have any questions, i’m ready to answer you. GL, Martin.

4

First mistake i see in the last field of your metadata. Delimiter is probably \r\n or \n.

OtaSanek