topic Re: How to Concatenate several rows into one field by a dimension in QlikView

How to Concatenate several rows into one field by a dimension

Wed, 02 Nov 2011 10:22:13 GMT

I wondering if you could concatenate several rows from the same column grouped by a dimension. Example:

Date, Comment

2011-01-01, One

2011-01-01, Two

2011-01-01, Three

2011-01,01, Four

The final result would be:

2011-01-01, One Two Three Four

In this case I am reading the data via a webfile by using the XML parser.

its_anandrjs — Wed, 02 Nov 2011 10:35:57 GMT

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

llauses243 — Wed, 02 Nov 2011 12:58:06 GMT

Hi,

Warning ¡

The previous solution not is complete, pls to see image atteched

Good luck, Luis.

Thu, 03 Nov 2011 13:32:35 GMT

Hello All,

Just simply add "Distinct" after the Load.

Hope it works,

Nima

lorenwood — Thu, 02 Aug 2012 16:25:00 GMT

Thanks Luis, your solution helped me