Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Active Directory load

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

23 Replies
jstar
Contributor III
Contributor III

@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
Contributor III
Contributor III

@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
Partner Ambassador/MVP
Partner Ambassador/MVP

This support article seems to match your case:

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

-Rob

AlbaJP
Contributor
Contributor

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