🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Data Prep Studio - Access Queries not displaying in full

User: "Altair Forum User"
Altair Forum User
Altair Employee
Updated by Altair Forum User

I have an Access Database with 75k rows.  I have a query that should display 32k rows.  In DPS, it only displays 6402 rows (all queries are displaying approx this number).

 

Is this a known issue?  Is there a solution?

Find more posts tagged with

English
Monarch
Sort by:
1 - 3 of 31
    User: "Altair Forum User"
    Altair Forum User
    Altair Employee
    OP
    Updated by Altair Forum User

    Is it safe to assume you have already checked for the default Data Source Row Limit setting?

     

     

    Grant

    User: "Altair Forum User"
    Altair Forum User
    Altair Employee
    OP
    Updated by Altair Forum User

    Is it safe to assume you have already checked for the default Data Source Row Limit setting?

     

     

    Grant

    Yep, no row limit is set.

    User: "Altair Forum User"
    Altair Forum User
    Altair Employee
    OP
    Updated by Altair Forum User

    Yep, no row limit is set.

    Ok.

     

    Well I went and found an old test database I have not used for a while and never in DPS.

     

    This one is showing just over 5 Million records in the mdb file and the query I chose extracts just over 550,000 records. The number of records repoeted as selected by the SQL query and DPS agrees.

     

    That suggests there is not a complete fundamental problem.

     

    Sadly it does not explain your result.

     

    FWIW I'm running V14.3 .

     

     

    Grant

Quick Links