topic Re: QlikSense Lookup Field Connection with SharePoint in Connectivity & Data Prep

QlikSense Lookup Field Connection with SharePoint

Flxvio043 — Tue, 30 May 2023 10:27:37 GMT

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

Re: QlikSense Lookup Field Connection with SharePoint

williejacobs — Wed, 07 Jun 2023 06:50:19 GMT

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.

Re: QlikSense Lookup Field Connection with SharePoint

woutermak — Wed, 07 Jun 2023 15:13:16 GMT

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.