Discussion Board for collaboration on QlikView Scripting.
I wondering if you could concatenate several rows from the same column grouped by a dimension. Example:
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.
Go to Solution.
Try to load like
Concat(Comment,' ') as NewComment
Group by Date;
See the attached sample file.
The previous solution not is complete, pls to see image atteched
Good luck, Luis.
Just simply add "Distinct" after the Load.
Hope it works,
Thanks Luis, your solution helped me