Compare data from data row of mulitiple columns data in datatable?

Help
1

I want to Check data exits or not in other columns in one table.
For example,

ColumnA ColumnB columnC
1 1 5
2 2 6
3 3 7
4 4 8

I want to Check Column A and Column B ,Column A and Column C,Column B and Column C
if data same,
For example ,I mentioned above.

Column A and Column B are the same data.At that time, I want to add Column names to the List.What Should I do?

1 Like
2

Buddy @Lwin_Moe_Aung

  1. Open excel application scope
  2. Read range activity to read the data
  3. For each row loop to iterate through the data
  4. If condition like
    row(0).ToString.Equals(row(1))
    If this equals you can the value assigned to a variable list initialised with default as new list(of string)…initialise this buddy before using a list…thats important
    Or
    If this condition doesn’t pass in else part use another if condition like
    row(0).ToString.Equals(row(2))
    Again the same in then art and leave the else part empty here buddy

Thats all you are done… kindly let know if this works or not buddy

Cheers

3

Is that working buddy… @Lwin_Moe_Aung

4

sorry for late reply.
It is working.
Thank you sir.

1 Like
5

Cheers buddy

Keep going

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.