I have one datatable in that I have 3 columns and 10 rows. Eg,
ColA. ColB. ColC
DF346. Yhkjuop. Yu5695
CZ950. Fhjsksj. To9835
CZ950. Fglqru. To9835
CZ950. Hsjaja. PO1276
I need to write the result in next column i.e colD.
For the 1st row we need to set bydefault value i.e 1 in colD.
Next, I need to check row2 of ColA and row2 of colC is same as above row or not. i.e we need to compare row2 to row1 .In a similar fashion we need to check row3 of ColA and row of ColC is same or not with the row2.
If rows are similar to above rows of ColA and ColC then write 0 in ColD.
If rows are dissimilar to above rows of ColA and ColC then write 1 in ColD
If only row of ColA is matching with the above row and row of ColC is not matching with the above row then write 0
It means we need to take “And” operation in between ColA and ColC
Please find the attached workflow. This will help you with the scenario mentioned. Please mark this as a solution if the rowComparsion.zip (12.5 KB)
workflow helped you resolve your query.
This is not working. I wrote this expression in assign activity but getting error.
"valye of type 1-dimensional array of string connot be converred to string