Active Directory load

[Anonymous]

I'm loading data from Active Directory.  The user select looks more or less like this:

SQL SELECT
distinguishedName,
cn,
displayName,
mail
FROM '$(vLDAP)';

Question: is it possible to load only the users who belong to a certain Group or several Groups before loading Groups themsleves?

Thanks,

Michael

[jstar]

@rwunderlich We also used your Script in Qlik Sense.

The same Error occurred: EQ_QVX_SIZELIMIT_EXCEEDED

Uncomment your FIRST 1000 line did not fix the error.
I placed the "FIRST 1000" comment before the SQL SELECT (3 lines down). This worked.

BUT:
After that, our Active Directory QVDs are incomplete. So its not a real Workaround.

https://support.qlik.com/articles/000053759?_ga=2.250601665.612611955.1569225269-847784564.154159536...

[jt422605]

@rwunderlich 

Thanks for your response.  Its commented. But even if  not the result remain unchanged as this is preceding load. And  >1000 rows retrieved from the AD directory before this step. 

[rwunderlich]

This support article seems to match your case:

https://support.qlik.com/articles/000053759

-Rob

[AlbaJPDupe]

Dear all,

I tried this code and it works for me:

Table:

Load *

;

First 1000

SQL Select

*

From table_name;

Hope it helps 🙂

Regards,

Alba