Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

1 to many Mapping

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

Tags (2)
Labels (3)
1 Solution

Accepted Solutions
Highlighted

Re: 1 to many Mapping

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

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

View solution in original post

2 Replies
Highlighted

Re: 1 to many Mapping

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

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

View solution in original post

Highlighted
Contributor II
Contributor II

Re: 1 to many Mapping

Excellent, exactly what I was looking for

Thank you