concat + set expression

[ZuzJesk]

Hi there, let's imagine I have a following sample table in the load script:

Document	Word	Context
AAA	Hi	1
AAA	there	2
BB	How	1
BB	are	2
BB	you	3
C	Hi	1
C	I	2
C	am	3
C	fine	4

In some field in the frontend, I'd like to concat the Words to a sentense, e.g. using simple Concat( Word, ' ', WordPosition) BUT if I filter some Word in a filter, it displays only the Word, not the whole sentense. Thus I need to change the contact expression to get all the words for the asociated Document, something like

Concat( {< Word=p(AllPossibleWordsForDocumentAssociatedWithTheWordSelection)>}Word, ' ', [WordPosition])

I'd really appreciate some help 🙂

[rwunderlich · Accepted solution]

Concat({<Word=, Document=P(Document)>}Word,' ', Context) 

-Rob

[ZuzJesk]

absolutely brilliant! and so easy! thanks a lot! 🙂