Array/Variable in SQL Where statement

Thu, 20 Apr 2017 14:29:47 GMT

Table 1 has a list of user names from a document. Table 2 is an OLEDB connection to LDAP. I'm looking to pull LDAP data based on a matching where statement for all users in table 1.

Example:

Users: LOAD [User ID] FROM UserList.xlsx (ooxml, embedded labels);

OLEDB CONNECT TO [Provider=ADsDSOObject;Encrypt Password=False;Integrated Security=SSPI;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648;FetchSize=100000];

HierarchyDB: SQL SELECT cn, displayname, l, c FROM 'LDAP' Where cn=[User ID];

I suspect I'd have to use some type of "For Each" statement but nothing seems to be working. Preferably for distinct items in User ID to avoid duplication of data.

topic Array/Variable in SQL Where statement in QlikView

Array/Variable in SQL Where statement