Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try to load like
load
Concat(Comment,' ') as NewComment
resident Data
Group by Date;
See the attached sample file.
Rgds
Anand
Hi,
Try to load like
load
Concat(Comment,' ') as NewComment
resident Data
Group by Date;
See the attached sample file.
Rgds
Anand
Hi,
Warning ¡
The previous solution not is complete, pls to see image atteched
Good luck, Luis.
Hello All,
Just simply add "Distinct" after the Load.
Hope it works,
Nima
Thanks Luis, your solution helped me