I am having a problem when trying to extract lookup data from SharePoint 365.
The main table we are extracting includes a list of products in one cell called a multivalue field I think its called. These values are pulled from a lookup table but when I use the SharePoint 365 connector it only gives me one value. I would expect the connector to give me the multiple values in order to connect to the lookup table in Qlikview but only having one value means its missing most of the data.
When I do the simple export to excel it gives me all of the values but separated with the # and a number like #1. This is what I was hoping to get through the connector.
Any help would be great,