Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question How to ignore error format and load a null value ?

More
23 Oct 2015 17:40 #1 by MathieuV
MathieuV created the topic: How to ignore error format and load a null value ?
I try to load a file with the replicator template.
In this source file, the are integer an string fields.
Sometimes, in numeric fields in source file there are letters.
For exemple : in month field we have 'xx' instead of '01'.
How to ignore this error and load NULL value in database when format is not respected ?

Thank you for your help.

Designer 17.2
Java 7 d'Oracle
Postgresql 9.4
OS : Debian Jessie
More
23 Oct 2015 17:53 #2 by Cyril Dussud
Cyril Dussud replied the topic: How to ignore error format and load a null value ?
Hi,

Did you try to use the options in "Reading Behavior" tab of the file metadata ?
There are options like "Field Format Error Behavior" for example.
More
23 Oct 2015 17:59 - 23 Oct 2015 17:59 #3 by MathieuV
MathieuV replied the topic: How to ignore error format and load a null value ?
Thank you.
I didn't see this options.
Last Edit: 23 Oct 2015 17:59 by MathieuV.