How to filter 2 columns based on some condition and write comments corresponding to the value

[bhanu.priya2 (Bhanu Priya)]

Hi All,
Above is my input data…
The task is, I need to filter “Grade” column which contains only C3 and C4
and again need to filter in the “country” column so i need to check against to C3 and C4…if the country is IN then i need to write comments in condition column as above, and if the country is US then also i need to write some comments, please help me…

[Srini84 (Srinivas)]

@bhanu.priya2

You can use Filter Datatable activity

“Grade” = “C3”
AND “Grade” = “C4”

After that you can use For Each row activity and inside use Assign Activity and place a switch activity

Hope this will help you

Thanks

[Gokul001 (Gokul Balaji)]

Hi @bhanu.priya2

Here is the workflow

FilterDT.zip (63.5 KB)

Hope it will work

Regards
Gokul

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @Gokul001 ,

Just now checked your code nice work. Could you please share the high level steps you have done for this automation with the screenshots if possible so that it would be helpful others who are looking for the same solution. thanks.

[bhanu.priya2 (Bhanu Priya)]

Hi Thanks for your reply, but i can see some missing activities.

if u don’t mind can you please tell me which are those missing activities

[Gokul001 (Gokul Balaji)]

@bhanu.priya2

This Activity is the “Message Box”

Goto Manage package update this package → Uipath.System.Activities

[Gokul001 (Gokul Balaji)]

Kindly let me know if you have any query related to this topic. If not close the topic @bhanu.priya2

Regards
Gokul

[bhanu.priya2 (Bhanu Priya)]

Hi Gokul,

Thanks for the solution, it is working fine.