topic Re: Getting text from one table and list it in another with commas... in App Development

Getting text from one table and list it in another with commas...

DEMONIO_AZUL — Mon, 23 Mar 2026 18:23:15 GMT

Hello there,
I have two tables, Document Table and Comment Table.
Document Table has rows with information, and the only thing I can get from this table is if each document has comments or not. The comments are in the Comment Table.

I am trying to get, for example, if Document A has comments, then I need all Comments listed in the Target Table, as follows:

Any ideas on how to achieve this will be appreciated.

Thank you!

Re: Getting text from one table and list it in another with commas...

WeLoveQlik — Mon, 23 Mar 2026 19:10:45 GMT

If I am understanding this correctly.

First, you need to create a key between Document table and Comment table since that doesnt exist.

It looks to me like that key is Document and the first letter on the comment table.

So, to create that key on the comment table side and then create your final table I would do the following

TargetTable:

LOAD Document

From DocumentTable.qvd(qvd)

WHERE Has Comment = 'Y';

LEFT JOIN (TargetTable)

LOAD LEFT(Comment,1) as Document

CONCAT(Comment,',') as Comment(s)

From CommentTable.qvd(qvd)

Group by LEFT(Comment,1);

Re: Getting text from one table and list it in another with commas...

DEMONIO_AZUL — Mon, 23 Mar 2026 19:32:06 GMT

This is perfect. Thank you @WeLoveQlik !!