Hi,
How do I match these 3 columns based on my arguments?
Could you please help me to solve this.
Hi,
How do I match these 3 columns based on my arguments?
Could you please help me to solve this.
Hi
Match means do you like to compare the values
Kindly elaborate a bit more in this pls
Cheers @Juliene
Yes @Palaniyappan. I want to compare the values.
For example my arguments :
Message Type - Add Auto Error
Brand - PW
Message - TestRPA
then I can click the button beside on that row, but if not match then error
3 arguments.
Message type, brand and message
Fine
Let’s take like we have tumour three arguments in a array variable named arr_inputs of type array(of string) with default value as {“value1”,”value2”,”value3”} defined in the variable panel
—now in the design use a excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
—then use a for each row loop and pass the variable dt as input
—inside the loop use a if condition like this
row(0).ToString.Equals(arr_input(0).Tostring) AND
row(1).ToString.Equals(arr_input(1).Tostring) AND
row(2).ToString.Equals(arr_input(2).Tostring)
If this condition matches it will go to THEN apart where we can use a click activity or it will go to ELSE part where we can give us a message with write line activity as “Error”
Hope this would help you
Cheers @Juliene