I am working on a excel file data comparison task. I have a master file where i will be getting unique account numbers and will be searching for a match in other 2 files. If the match is found we will be logging in success or else error. So i need to run at master file level. I was instructed not to use orchestrator for this and hence changed transaction queue item to string and removed queues related fields( transaction fields). When i run im getting the multiple errors as in image. Can someone help asap
You haven’t changed the TransactionItem datatype to string. Also looks like you deleted the default variables like TransactionField1
first thing you dont need to delete anything
for changing REF from queue to string ..you need to change the variable type in get transactiondat,process,main and then relink the arguments in import arguments in invoke workflow file
set transaction status will not write if nothing is send as input to transactio item in import arguments
dont delete or change anything else
cheers
Seems like you haven’t changed the variable type of TransactionItem to string.
You need to update argument type to String in Main.xaml, GetTransactionData.xaml, and Process.xaml.
Then Remove all references to: TransactionItem.SpecificContent, TransactionField1, TransactionField2, TransactionID.
Also remove Orchestrator activities: Add Queue Item, Get Transaction Item, Set Transaction Status.
Since you are using string as transaction item,
In GetTransactionData.xaml: read Excel and assign
out_TransactionItem = Dt.Rows(TransactionNumber)("ColName").ToString.
UiPath Tutorial 25- UiPath ReFramework with Excel |UiPath Real Time Project
@Teja_Chodavarapu change the Transaction Item variable to string and for TransactionField2 is not defined error go to set transaction state and check weather you have deleted any variable
You could take a look at the academy course below.
It shows you what needs to be changed in order to go from Queue to Tabular data.
Regards
Soren