Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi you need to cast date in proper format.
Can you post few lines of data in an excel.
Regards
ASHFAQ
Please see attached.
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.
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
I tried the same but still showing same and there is three rows with Chinese language would that create any problem?
Hi try to load by commenting chines fields and check if that can help.
Regards
ASHFAQ
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';
Hi try below
Table:
LOAD
ID,
...
....
....;
SQL SELECT *
FROM data;
where ID not in ('453015579' ,'20857');
Regards
ASHFAQ
I tried it is showing data type mismatch in criteria expression
Hi try below
Table:
LOAD
ID,
...
....
....;
SQL SELECT *
FROM data;
where ID not in (453015579 ,20857);
Regards
ASHFAQ