1 to many Mapping

[rupshall10]

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

[rubenmarin · Accepted solution]

Hi, using subfield you can create many rows from 1:

LOAD Applymap('mapName', Trim(Subfield(FieldName, '#;'))) as MappedFieldName

[rupshall10]

Excellent, exactly what I was looking for

Thank you