ETL and Data Integration tools - Modern ETL software for everyone

Help me please:

I downloaded evaluation version of Visual Importer Professional version 7.3.5 from your web side. When I tried to play around to import data from access oracle database, I found even if I picked some fields as "if NULL reject" option, but the data were still imported into target table, is this because the software is evaluation or something else?

Thanks,
Matt

Hi.

There are no trial limitations what so ever in our software.

I can assume that your fields do not actually contain nulls but strings with length equals to 0
If you want to filter them out you can use sql statement as a data source or use integrated filter

Mike

Thank you Mike for your reply.

The field did contains nulls because when I tried to use the following query:
select * from sender where dept_code is null

it listed all records which dept_code contains value null.

If I use this query:
select eid, first_name, last_name, length(dept_code)
from sender

it listed the length for each record of dept_code except of showing nothing for null values.

Any suggestions? I could write script to filter them out but I just want to see if the software could provide me such functionality or not.

Thank you again.

Matt

If you use this expression Trim([yourfield])!='' as a filter it should do the trick

Mike