Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Tags (2)
1 Solution

Accepted Solutions

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

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

4 Replies

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

Hi,

Try to load like

load

Concat(Comment,' ') as NewComment

resident Data

Group by Date;

See the attached sample file.

Rgds

Anand

llauses243
Contributor III

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

Hi,

Warning ¡

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

Good luck, Luis.

Not applicable

How to Concatenate several rows into one field by a dimension

Hello All,

Just simply add "Distinct" after the Load.

Hope it works,

Nima

lorenwood
New Contributor III

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

Thanks Luis, your solution helped me

Community Browser