Flat File - Manage header line

, ,
1

Dear all,

I would like to turn a CSV flat file into IS Pipeline using convertToValues standard service. We also have defined many Format Services in order to check and turn some fields during this global conversion (for example, checking date formats…)

This works properly but as received flat files have an header line containing ths names of CSV File columns, the first line triggers validation errors.

How can I skip validation (format services) for the header line ?

Thank you very much for your help.

Jean-Charles

2

You’ll need to ignore the header line in your code. There are options in the service call that can add a line number to the returned record. You can check that to ignore the header. Or look for a specific string that occurs only in the header.

3

I confirm.
The parameter that must be used is addRecordCount in ConvertToValues service !
[FONT=PalatinoLinotype,Italic][SIZE=2][FONT=PalatinoLinotype,Italic][SIZE=2]Thank you Rob
[/size][/font][/SIZE][/FONT]