Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list in SharePoint linked to qlik.
I need to map one of the location field to a separate table.
My issue is in SharePoint you can select multiple locations, they are pulled across as 1 long string.
i.e
Record 1: Site 1#; Site 2#; Site 3
Record 2: Site 1
Record 3: Site 2#; Site 3
I'm imaging a mapping table with the condition, if the field from SharePoint contains the field in the Location Table then link the two, but I have no idea what this might look like. Any help appreciated
Hi, using subfield you can create many rows from 1:
LOAD Applymap('mapName', Trim(Subfield(FieldName, '#;'))) as MappedFieldName
Hi, using subfield you can create many rows from 1:
LOAD Applymap('mapName', Trim(Subfield(FieldName, '#;'))) as MappedFieldName
Excellent, exactly what I was looking for
Thank you