I have a DBF file with the first row empty and other DBF files with blank numeric fields.
I’m doing a very simple graph: DBF Data Reader to Trash.
I have set the DBF Data Reader Policy to Lenient but get a Runtime exception of the form: in node DBF_DATA_READER0 : java.lang.RuntimeException : QTY cannot be set to : in record # 0 in field # 0 when parsing record #0 field QTY value " "
I have set the metadata field entries to nullable and have provided suitable defaults.
I’ve tried a filter to ignore the first row but the filter doesn’t get called.
What else do I need to do?
cheers
Dave