Use Two excel files in REFramework

[ignasi.peiris]

Hi @Teaf ,

Depending on your requirements, you can build that logic in the “Process” and in order to only run it once, you can change the following condition:

Workflow: GetTransactionData.xaml

• out_TransactionItem isNot Nothing Change to in_TransactionNumber = 1
• This will allow the bot to enter the process only once.

Then inside the process, you can perform the comparisons. On the post below, you’ll find 2 LINQ Queries to compare DataTables, that would suit your needs

• You might need to modify them a bit due to different requirements

In excel, I want to compare 4 columns in same sheet "statements" with other 4 columns in same sheet column name are same ,and write difference of 4 columns between in next "Difference sheet"?

I want to compare 4 columns in same sheet “statements” with other 4 columns in same sheet column name are same ,and write difference of 4 columns between in next difference sheet? Reconcilation702580111110.xlsx (8.3 KB) [image] column name credit debit description and date [image]

Hope it helps!