I’m building an automation through ReFramework but I need to compare the current transaction Item against the previous transaction item to decide how to proceed with the process.
Transaction items looks like this:
|Invoice||Line Item||Sub Line Item|
I Used bulk add activity to add queue items onto orchestrator. The method that I used and failed with is to set up two sets of variable:
NewInvoice, NewLineItem, NewSubLineItem and ProcessedInvoice, ProcessedLineItem, ProcessedSubLineIte
At the beginning of the process state, the “New” variables would be assigned with the current transactionItem specific content.
Then at the end of the process state, assign the current transactionItem specific content to the “Processed” variables.
The idea is to compare is to compare the processed variables vs the new variables each transaction. However, I found that the “processed” variables doesn’t hold the value and becomes default after each transaction.
I’ve also tried to add the “Processed” variables onto a data table and it still doesn’t hold the variables after each transaction.
I have two options in mind to solve this. One is to move the assign activity for processed variables to “SetTransactionStatus”, seeing if the variables would hold its assign value for the “Process” State to use before its reset to default once it goes to “SetTransaction”.
Second option is to create a separate queue on orchestrator to upload the processed transaction and use that to compare with the queue where I get the “new” transaction variables from.
Third is maybe an external excel sheet? However, trying to use minimal application if possible.
Please let me know if anyone has had an experience with a process like this and thanks!