Here's an approach:
LOAD Product, RecNo() as ProductId INLINE [
LOAD *, recno() as CommentId INLINE [
I love Product No2
I am interested in Product No1 but I am not sure
Does anyone know if Product No2 is better than Product No4
Product No3 that's it!
Product No1 I'd like to buy
MAPPING LOAD Product, '<'&ProductId&'>'
,PurgeChar(ProductRef,'<>') as ProductId
WHERE ProductRef LIKE '<*>'
,subfield(MapSubString('ProductMap', Comment),' ') as ProductRef
For aother approach when mapping single words, see
Qlikview Cookbook: Indexing Keywords in Text http://qlikviewcookbook.com/recipes/download-info/indexing-keywords-in-text/