How to check if data of a particular column has same value in all the rows in a dataTable
Change the value to Column2 in the below screenshot, you will get all the value NOT same message.
Hope this helps.
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)