Split column and replace with associated fields and concatenate

[jonathandienst]

Something like this:

MAPSEGMENTS:
Mapping LOAD Segment, SalesRepID
FROM ....;

Data:
LOAD Segment,
	SalesRepID,
	RouteSegment,
	MapSubString('MAPSEGMENTS', RouteSegment) as RouteSales
FROM ....;

 PS: posted in wrong forum. Should be posted to a Qlikview or QikSense forum, not the community forum.