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.
To-do: 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.
That’s like an exceptional case, if there is an idle value present then I need to add a row just before the total in the result sheet and add that value in the Debit column since its negative**(Only in case of DR)**.
@AryanSingh I didnt complete it properly to the required format , If you already downloaded the File, Check it , else I’ll try to complete it to the required Output Format and Upload it here
Sorry brother, I was checking it, but I cannot build a data table from my side, There is a final excel where I have write these values individually depending on the situations. (“Using the write cell activity”)
this is the main result file. I will be writing the individual values of similar positive and negative values in the Payments and Invoiced Column just before the *"Total due from "column
Please check.
P.S. I want to save these values variable so that I can use these values.
I am just trying to retrieve the same positive and negative value from the export file at the same time and write them in the excel directly (without using the result excel in datatable form due to format changing issues!)
And if there is an idle value of DR type then need retrieve it separately in other variable.
This is a monthly process so 2 columns will be added every month, that’s why the column name and index will be different every time, that problem of calculating the dynamic index for row and column is already resolved from my side. That is why I said that column and row are dynamic.
Final excel will have value, yes but the target column and row will be empty. Hope this clear the doubt.