DT columns

Hi! I have DT.
I need take value from the third column, if first and second columns equals my values.
I did:
For each row in DT
if (DT.Columns(“col1”).ToString.Contains(val1) and type.Columns(“col2”).ToString.Contains(val2))
assign: val3 = DT.Columns(“col3”).ToString

My DT filled, but I get empty message box with val3

  • For each loop row in DT
    If row(“col1”).ToString.Contains(val1) and row(“col2”).ToString.Contains(val2)
    assign: val3 = row(“col3”).ToString
2 Likes

@RPA3

It should be like this.

          ForEach row in DT
                If row("Col1").Tostring.Contains(val1) AND row("Col2").Tostring.Contains(val2)
                 Then 
                   val3 = row("Col3").Tostring
                    Print val3
4 Likes