I am trying to compare data from one datarow to other data row in the same excel and if it matches then I want to perform some actions using those particular data retrieved from both the rows and write them in another excel.
And if there is like an Idle data, then the then need to perform another workflow.
1. if PY type amount matches with the DR type amount; eg. 1379,79 is matching with the -1379,79. We have to save these value in separate variables and write in another excel file.
2. If the value is Idle like -1576503,47(This value can be of any type PY or DR), then we need to perform another set of instruction.
Excel file is provided below:
EXPORT3.XLSX (9.9 KB)
Can anyone help me?
Thanks & Regards