Data Prep Studio - Access Queries not displaying in full

Altair Forum User
Altair Forum User
Altair Employee
edited February 2018 in Community Q&A

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?

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited February 2018

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

     

     

    Grant

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited February 2018
    Altair Forum User said:

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

     

     

    Grant

    Yep, no row limit is set.

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited February 2018
    Altair Forum User said:

    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

Categories