I’m working on reconciliation project, I have two CSV datasets as inputs (DataCOLL, DataTRE)
where they have the same format
DataCOLL: BANK, Currency, Total amount
DataTRE: BANK, Currency, Total amount
so I need to look up for the same BANK value in the both of datasets, so I can compare between their total amount and return the difference, Difference = totalAmount (DataCOLL) - totalAmount (DataTRE)
Hi @imane.bousaad ,
Check the below post, it seems the Query is similar :
Thank you @supermanPunch i will try what u suggest
1 Like
@supermanPunch I tried the data join solution, but i get as an error “Get Row Item: 629078665,01 is not a valid value for Double. (Parameter ‘value’)”
Could you show us what was the configuration done ? Or which activity gives out the Error ?
@supermanPunch of course thank you for help
Did you check the post that I have provided above ? The suggestion was to use Join Datatables activity, was that part done ?
yes I worked with join datatables activity, but the error occur on get row item
The Steps suggested would not need you to use the Get Row Item activity. After you have performed the Join with the two datatables, we can loop through the Joined resultant datatable and perform the computation for each of the rows.
If this is the expectation, then the Get Row Item would just be an extra step and would not be required.
Or is this a new case/requirement entirely ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.