how can i check if an entire column has same value or an entire row has same value from a datatable.

Hi @SRASHTI_PATIL If you want to check the entire column with the same value you can use the below LINQ Expression, -> Bool_SameValue = If(dt_ExcelData.AsEnumerable().Select(Function(x) x("Column name").ToString()).Distinct().Count() > 1, False, True) Bool_SameValue is the boolean datatype variab…

Excel Automat

Help Studio

sharazkm32 (Sharaz K M) January 16, 2025, 6:40am 2

We have option to remove duplicates. Kindly check this activity and see if it suffixes your requirement

Topic		Replies	Views
How can i check if an Excel column contains the same value in every cell? Activities datatable , excel , orchestrator , robot , activities , studio , studiox , question , linq	1	859	August 2, 2022
How to check all the values in a particular column is similar StudioX studiox , question	7	2258	October 20, 2021
A certain column contains a same value it should returns a boolean StudioX studiox , question	2	1062	October 19, 2021
Check if all the cells in a column have the same value Help datatable , studio , question	3	3862	September 15, 2020
How to check if there any duplicate data in a row from data table then output as Yes or No Activities question , system	8	623	August 29, 2023

Excel Automat

Related topics