Continuing the discussion from Linq Query to get the count of a value in particular column of datatable : [image] Linq Query to get the count of a value in particular column of datatable (Function(r) r("Invoice Number").ToString="INV002") Regards, Hey, What if the string “inv002” is dynamic? …

HI @Ray_Sha1 [image] Linq Query to get the count of a value in particular column of datatable (Function(r) r("Invoice Number").ToString="INV002") Try this instead of the above (Function(r) r("Invoice Number").ToString.ToUpper="INV002") Regards Sudharsan

Count is similar names present in the list and save it as datatable

Help Activities

Sudharsan_Ka (Sudharsan Ka) January 11, 2023, 8:00am 2

HI @Ray_Sha1

Try this instead of the above

(Function(r) r("Invoice Number").ToString.ToUpper="INV002")

Regards
Sudharsan

Topic		Replies	Views
Linq Query to get the count of a value in particular column of datatable Activities datatable , excel	5	5193	October 21, 2021
From a list of strings to get the count of similar items Activities datatable , excel , uiautomation , orchestrator , activities , studio , studiox , question , linq , list , linq-query , linq-quey , datetime-linq , linq-loop , datelime-linq	5	902	January 11, 2023
Filter the Column Values and get it Count in linq Studio studio , question , activities_panel	21	1503	June 26, 2023
Need to find the count from Datatable Help	14	7178	February 4, 2021
How to get specific value Count rows from specific column in datatable Activities activities , studio , document_understanding	5	1379	January 3, 2023

Most Active Users - Yesterday
Anil_G
Srivennila_Anandan
mudkipZ
Umut_Veysel_DURKEN
Venkat4
More details...

Count is similar names present in the list and save it as datatable

Related topics