Datatable Column Activity

How to check if data of a particular column has same value in all the rows in a dataTable

@Sana_Afreen - Are you looking for something like this? CheckColumnValue.zip (42.4 KB)

Output:
image

Change the value to Column2 in the below screenshot, you will get all the value NOT same message.

image

Hope this helps.

Hi @Sana_Afreen
You can check it by using a certain query which iterates through each row and particular column while checking for certain value…
Here am attaching the sample xaml please go through it and let me know if you could resolve your issue.
ExcelColumns.xaml (5.0 KB) SampleExcel.xlsx (8.5 KB)