All records are not loading from access table when loading into qvw?

[#1]

Hi,

I have ms access database tablw which have records 60,000 when I am loding into qvw it is sloading only 12,000 records. can anyone please suggest why there is less count of records loading.

Thanks.

[ashfaq_haseeb]

Hi you need to cast date in proper format.

Can you post few lines of data in an excel.

Regards

ASHFAQ

[#3]

Please see attached.

[#4]

Amelia, there is a way to narrow down the cause. For loading this table, replace load statement with load * on a test QWVs. See if there is 60,000 loaded into your app.

If yes, you would know this is because of the transformation issue from load statement. Check columns one by one to see which transformation cause this issue. As it describe at your uploaded image, it's because that your date function is invalid on specific columns, which may result in data missing.

Further, check if there is where condition to filter the data, and search if there is keywords like "limit", "First", which you haven't excepted yet.

[ashfaq_haseeb]

Hi,

Try by casting date for all date field.

Like below

load

F1,

date(date#(Datefield1,'DD/MM/YYYY'),'MM/DD/YYYY') as Date1,

date(date#(Datefield2,'DD/MM/YYYY'),'MM/DD/YYYY') as Date2,

F4;

from <accessDB>

Replace 'DD/MM/YYYY' with proper date format in database

and replace 'MM/DD/YYYY' with your required format.

Hope it helped.

Regards

ASHFAQ

[#6]

I tried the same but still showing same and there is three rows with Chinese language would that create any problem?

[ashfaq_haseeb]

Hi try to load by commenting chines fields and check if that can help.

Regards

ASHFAQ

[#8]

when I am using below it is showing error as syntax in correct. The below ID have Chinese language

Table:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID<>'453015579' and ID<>'20857';

[ashfaq_haseeb]

Hi try below

Table:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID not in ('453015579' ,'20857');

Regards

ASHFAQ

[#10]

I tried it is showing data type mismatch in criteria expression

[ashfaq_haseeb]

Hi try below

Table:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID not in (453015579 ,20857);

Regards

ASHFAQ