Few missing records from data load from oracle sql to qlik sense desktop

[dreweezy]

Hello all,

I have loaded about 300 records of data. In my oracle database I have 300 records for a column that is a varchar (some records can be numbers, numbers+string, or just string). When I use the wizard and import into Qlik Sense, it is missing roughly 5 records after doing some data validation. What could the cause be? I am confused as to how these specific 5 records can go missing. The varchar datatype suffice as 295 records properly import. The missing fields are not any different. Can anyone shed some light? 

Thanks

[pradosh_thakur]

What is the infomation density for that column in qliksense and is there any Where clause or filters applied ?

[dreweezy]

There is no where clause pre set before loading data. Everything was loaded using the built in wizard. 

Column A

abc

def

ghi-890

ttz-01

ttz-02

ttz-03

My data is pretty much similar to what is shown above. For some reason, qlik is unable to bring in the ttz01-03 records.

[pradosh_thakur]

Can't comment without seeing the script. Did you check the information density ?