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


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…

@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

Hi @bhanu.priya2

Here is the workflow

FilterDT.zip (63.5 KB)

Hope it will work

Regards
Gokul

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.

1 Like

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

image



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

@bhanu.priya2

This Activity is the “Message Box”

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

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

Regards
Gokul

Hi Gokul,

Thanks for the solution, it is working fine.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.