Check whole column Contains the same value

[anmita]

Hello Team,

Is there a way to check the whole column data contains 1.1

Example ANA is a column name that contains 1.1 so it should return true so further actions can be performed

ANA | JNN
Amt | Amt
An01|Jn03
1.1 | 2.3
1.1 |2.3
1.1 |2.3
1.1 |2.3
1.1 |2.3

[Yoichi]

Hi,

How about the following condition?

dt.AsEnumerable.All(Function(r) r("ANN").ToString.Contains("1.1"))

Regards,

[Manju_Reddy_Kanughula]

@anmita

Check here

Sequence.xaml (8.4 KB)

[ushu (Usha kiranmai)]

@anmita

Is there a way to check the whole column data contains 1.1

Hi @anmita - Try the below exp

Variable of type Data Table (DT1) = DT.AsEnumerable.Where(Function(x) Not x(0).ToString.Equals("1.1")).CopyToDataTable

• It returns the data table contains any value beside 1.1 to DT1. If there are no, it simply gives an exception that you can handle using Try Catch block. In the catch block you can take a boolean variable set to True
• This gives an idea, if this variable is set to True, that means there are value other than 1.1 in that column, else no

Check attached workflow

DataTable.zip (2.9 KB)

[anmita]

Hii @Yoichi

Thanks for the quick response can we check after 2 lines after column name

[anmita]

Thanks @Manju_Reddy_Kanughula

[anmita]

Thanks @ushu

[Yoichi]

HI,

How about the following?

dt.AsEnumerable.Skip(2).All(Function(r) r("ANN").ToString.Contains("1.1"))

Regards,

[anmita]

Thank you @Yoichi