Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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.
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.
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