Need help with finding the specific cell value using colum and row name

Help Studio
, ,
1

Hi , I have 2 Data Table DT1 and DT2 when I loop through the DT1, I will get the column and row value of DT 2.
DT2
image

For eg:I need to find the cel value of “Row A” and “Column CA” as 1
Row C and Column AZ as 1 and so on …

Can anyone help me, how to get the particular cell value at the run time in C# code .
Thank you .

2

is it about find the column name for a row where the datacolumn value = 1?

3

no the data colum value will be anything 0 ,1,2 or 3 .it should fetch the cell value based on our row and column value at runtime .

4

not really sure what is meant as we can access on a datatable

YourDataTableVar.Rows(0-basedRowIndexAsInt32)(ColumnNameOr0-basedIndex)

Maybe you can illustrate by the 2 datatable and a sample case

5

when I loopthrough the DT1 i will get Category as “A” and state as “AZ”
using these value I have to loop through the DT2 to find the cell value of [A][AZ].
I am not passing row index or column index .

6

had you crosschecked Lookup DataTable Activity so far?

As we also could understand:

Look for Category=A what is the value of Column"AZ"

7

I checked it alreday .It did not help me .The column name will not be same for the entire process . Row and column name can change. It is easy to get the cell value with index MatrixDT.Rows[0][1].ToString() , I am just wondering how can we get the same using column and row name using C# code.

8

here you would work with Variables and have it dynamized. However just confirm:

we have understood in the right direction?

9

Yes ,next Category=B and what is the value of Column “AZ” “CA” and so on .
MatrixDT.Rows[0][1].ToString() → in this I am using index to find the cell value,but in my case I have to use name value.