Filter table - summarize values from multiple rows

[bartek_polakowski]

Hi,

I have a training report with a simple structure

User ID	Training title	Training status
User 1	Training 1	Completed
User 1	Training 2	Started
User 2	Training 4	Completed
User 3	Training 1	Completed
User 3	Training 2	Completed
User 3	Training 3	Completed

Now I need to somehow collect users who completed Training 1, 2, 3 and have a separate column for the saying that WHole curriculum is completed. Any hint?

[Emil_Kos]

Hi @bartek_polakowski,

I have created a workflow for you:

There are probably hundreds of ways to achieve this. I like to use the summarize tool to remove duplicates and create concatenation of fields. The last step is joining the data back to the original data set and use a formula in order to check if condition was met. 

The output:

[bartek_polakowski]

Thanks Emil. Works great. However I have problem with one training called "Digital Upskilling: Tech While You Trek - Bringing Robotics to the People" 

When I include it in this part it always say No, even if someone have completed all three courses.

IIF(Contains([Trainings completed], 'Risk considerations for automations,UiPath RPA Awareness,Digital Upskilling: Tech While You Trek - Bringing Robotics to the People'), 'Yes', 'No')

[afv2688 · Accepted solution]

Hello @bartek_polakowski ,

Training names cannot be separated by commas on a contians condition, you would need to change the way you do it, you could either use join or a different solution, like a filter with "AND's"

Regards

[bartek_polakowski]

Hi afv2688

That's strange because it works for this sample

 IIF(Contains([Trainings completed], 'Training 1,Training 2,Training 3'), 'Yes', 'No')

The problem is with the longer title. I thought that's maybe because of the special characters.