How to Concatenate several rows into one field by a dimension

[#1]

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 · Accepted solution]

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

[llauses243]

Hi,

Warning ¡

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

Good luck, Luis.

[#4]

Hello All,

Just simply add "Distinct" after the Load.

Hope it works,

Nima

[lorenwood]

Thanks Luis, your solution helped me