I have a data table and an if statement - I would like to say 'if column 1 in this data table =(variable)
I have this so far but unsure how to configure correctly:
I have a data table and an if statement - I would like to say 'if column 1 in this data table =(variable)
I have this so far but unsure how to configure correctly:
Hi @E.T.S
Try this:
dtCorrespondingTab("column1").ToString.equals(strKeyArea.ToString)
we would assume that you was iterating over something with a for each / for each row
However we cannot derrive all details from above given information
We suggest to tell us the entire scenario and what has been modelled so far
I am comparing two Excel files - I have used a read range for one Excel file, if the column of one matches the column of another copy the row
Sorry, a more clear description is welcome. Feel free also to illustrate your case with sample data
sound like a match case of ??
Use this syntax in If activity @E.T.S :
CurrentRow("column1").ToString.Trim.Equals(strKeyArea)
Hope it helps!!
Apologies
I am comparing a data table with a variable - the process checks each row in the data table and compares it to the variable to see if there is a match
Please could you the implementation of match case in this scenario