Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I hope you are all doing good.
I have a question to a QlikConnection with SharePoint. I connected my Qlik With a SharePoint list and it works well, but unfortunately I have some Lookup Fields in my SharePoint lists which are refering to other lists. I'm not able to load them to the Qlik and they are really important. As example I mapped Country, Sub Region, Cluster in another list in the SharePoint. Is there a option to load also the lookup Fields or is it not possible. Otherwise is there a workaround?
Thanks and kind regards
Flavio
Hi Flavio,
Load your primary table, left join and load the list used for lookup.
Alias your key field with the same.
Hope this helps with your problem.
Hi Flavio,
You can use applymap() for lookup fields.
First load your lookup fields with mapping load
then load your other data and use applymap to use the lookup value.