topic 1 to many Mapping in QlikView

1 to many Mapping

rupshall10 — Sat, 16 Nov 2024 20:20:13 GMT

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

Re: 1 to many Mapping

rubenmarin — Thu, 01 Aug 2019 17:42:55 GMT

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

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

Re: 1 to many Mapping

rupshall10 — Mon, 05 Aug 2019 13:33:56 GMT

Excellent, exactly what I was looking for

Thank you