How to get data from datatable according to the content

[manoj2500 (robo)]

hi ,

I am working on this excel what i want to do is I want to get those ticket numbers that matches the message status as – error message 51 retry

[Lakshay_Verma]

@manoj2500

Hey Use this and assign it back to a datatable.

(from dr as datarow in dt where dr.item("massage status").tostring.equals("error message 51 retry") select dr).copytodatatable

[manoj2500 (robo)]

@Lakshay_Verma getting this error

[Lakshay_Verma]

@manoj2500

Use this and you do not need to use for each
dt=(from dr as datarow in dt where dr.item("massage status").tostring.equals("error message 51 retry") select dr).copytodatatable

[manoj2500 (robo)]

@Lakshay_Verma

[Lakshay_Verma]

@manoj2500

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

[ppr (Peter Preuss)]

For the datasetextensions have a Look here

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

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]

@ppr Thanks for adding this.

@manoj2500 You have to follow above steps.

[manoj2500 (robo)]

@Lakshay_Verma i added it manually now i am getting this error

i am adding the xaml Main.xaml (8.7 KB)

[supermanPunch (Arpan)]

@manoj2500 For Handling that error, you might need to check this post :

Filter expression in data row

@BOTFORCE Actually there is an additional Step involved in it, Which I believe I have not said. When the CollectedDataDT has no rows Corresponding to entry_id which is matching in Other DT , it gives out an Error. There are mainly two ways of Handling that error: You can use a Try Catch Method, Where you enclose the Assign Statement in Try and use another assign Statement in Catch Block to assign an Empty Datatable. You can perform thsi as shown in the Screenshots below [dtarray] [dtarray1…

[Lakshay_Verma]

@Manoj2500

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

[Pratik_Wavhal]

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

[manoj2500 (robo)]

can you help me what i need to do if i need to remove this one need other status types in datatable

[Lakshay_Verma]

@manoj2500

dt= (from dr as datarow in dt where dr.item("message status").tostring<>"error message 51 retry" select dr).copytodatatable

[manoj2500 (robo)]

it giving me all tickets output screenshoot

[Lakshay_Verma]

@manoj2500

write range in sheet 2

[manoj2500 (robo)]

@Lakshay_Verma i am creating a new excel and passing thru write range

[Lakshay_Verma]

@manoj2500

(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.

[JithinGangadharan]

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()

[manoj2500 (robo)]

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