XLS null record

CloverDX Platform
1

Hi, I am reading a XLS file and writing this to a Postgres dB. The problem I have is that the last record written has a null value. I presume that this is to indicate that the last record has been reach. Since there is a varying number of records, I cannot set the last record value.

Is there any way I can avoid this last “null” record being written?

Thanks
Des

2

Hello,
you have empty line in your xls file probably, that is read by clover (manualy removed?). You can put ExtFilter component after reader that allow to pass not null records only.

3

Yep, that did the trick thanks
:smiley: