I have a group of staff and there is feedback from the survey.
As you can see in the picture, i have Andy, Susan,Peter, Dickson and Rainy.
Each of them have a set of comments and the number of comments is not fix.
How do i tell Uipath to pick the comments belong to individual only? That output look like below:
The ultimate goal of this is for automate email, that can sent out the set of comments to individual in email. I can do email to replace variable but with a set of comments under 1 column i have no idea how to do it.
I have tried your method, I have a lot of error on the assign variable. First is Tablelist. I have try and error, between string, datatable,generic all don’t work in the end i use list and the error Icon is disappeared.
Next is the arrFeedback I change to Array of String, error is gone. I have no idea am i doing the correct thing. Next I need to Write range but arrFeedback variable is not in system.datatable and how do i do it?
the issue comes from following:
arrFeedback is a string array and not a datatable. Therefore it cannot be used within the Write range. Give a try on using table representing the grouped data from current loop.
Really appreciate your help. I have been repeatedly reading the groupby sample in the attachment link.
The data i have is only two columns, column(0)(“Staff name”), Column(1)(“comments”)
Staff name is repeating and to their unique comments in the excel without sort.
So the goal is to group them like the example below:
Staff name | comments
Peter | You are helpful
| Friendly and polite
| You should be the manager
| You are very well groom and polite
Lynn | You need to improve your English
| You need to speak louder as the environment is too noisy.
I need output in excel because I need to lookup the email address to the staff name. In the last part is email
Below are your comments in the survey:
You are helpful
Friendly and polite
You should be the manager
You are very well groom and polite