Click on import and add assembly reference System.data.datatable and System.Data.DataSetExtensions
If that does not work downgrade your UiPath.System.Activities to 20.4.0
For the datasetextensions have a Look here
Ensure system.linq, system.linq.expression is imported (Imports Tab, Close to variable panel)
Shift Statement from
in dt to
in dt.asenumerable
Give a try and Let US know the feedback
@Lakshay_Verma i added it manually now i am getting this error
i am adding the xaml Main.xaml (8.7 KB)
sorry, it’s a typo… i have typed massage
instead of message
… Please correct this
dt= (from dr as datarow in dt where dr.item("message status").tostring.equals("error message 51 retry") select dr).copytodatatable
HI @manoj2500
Check the below workflow for the same. It is giving the ticket numbers that matches message status as – error message 51 retry.
MainPratik.xaml (9.3 KB)
Forum _ Manoj.xlsx (9.5 KB)
Mark as solution and like it
Happy Automation
Best Regards
Er Pratik Wavhal
can you help me what i need to do if i need to remove this one need other status types in datatable
dt= (from dr as datarow in dt where dr.item("message status").tostring<>"error message 51 retry" select dr).copytodatatable
(from dr as datarow in dt where not dr.item(“message status”).tostring.equals(“error message 51 retry”) select dr).copytodatatable
Can you try this.
Can you try the below code?
DT = DT.AsEnumerable().Where(Function(dr) dr.Field(Of string)("message status").ToLower().Equals("error message 51 retry”)).CopyToDataTable()
hi @Lakshay_Verma @JithinGangadharan @Pratik_Wavhal
if error message 51 retry remain same and values after that are changes then what we can do get all values starting like error message 51 retry
ex. error message 51 retry by 40 gm
error message 51 retry by 76 gm
(from dr as datarow in dt where not dr.item(“message status”).tostring.contains(“error message 51 retry”) select dr).copytodatatable
(from dr as datarow in dt where dr.item(“message status”).tostring.contains(“error message 51 retry”) select dr).copytodatatable
Hi @manoj2500
StringVariable.StartsWith(“error message 51 retry”)
This can give you all the fields which will start with “error message 51 retry”
Mark as solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal