Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Concatenate several rows into one field by a dimension

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.

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

View solution in original post

4 Replies
its_anandrjs

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

View solution in original post

llauses243
Creator III
Creator III

Hi,

Warning ¡

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

Good luck, Luis.

Not applicable
Author

Hello All,

Just simply add "Distinct" after the Load.

Hope it works,

Nima

lorenwood
Contributor III
Contributor III

Thanks Luis, your solution helped me