Hi, I need to somehow check DT row value results for a particular variable value. If the value is found then populate a field. If the value is not in the DT then to throw an error. Is this possible please? Thanks T

Hi, @TRX You can achieve this using the .Any method like this dt_Invoices.AsEnumerable.Any(Function(x) x("NF").ToString.Trim = "131212312312312") You can use any column to search for specifc value and compare. If at least one is found, the expression returns True [image] To throw a error, you …

Can I check datatable outputs for a particular value using an IF statement?

Help Studio

Nguyen_Van_Luong1 (Nguyen Van Luong) November 27, 2023, 1:33am 3

HI @TRX ,
Similar topic

regards,

Topic		Replies	Views
Datatable query Activities excel , studio	4	505	March 30, 2023
Check Excel cell value & use If activity Studio datatable , excel , uiautomation , studio , question	11	3626	August 12, 2022
How to check if certain values are not found in specific column? Studio datatable , question	11	2650	December 21, 2021
Search value in Excel Particular column and Print "Found" or "Not Found" Studio uiautomation	9	1180	July 28, 2022
How to check specific value is present in datatable or not? Studio studio , question , activities_panel	14	670	January 21, 2024

Can I check datatable outputs for a particular value using an IF statement?

Related topics