QlikSense Lookup Field Connection with SharePoint

[Flxvio043]

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

[williejacobs]

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.

[woutermak]

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.