I want to read another sheet in Re. Can someone show me a workflow how can I do it.
I have read sheet with in_transactionItem variable which was already used in Re. I dont know how to read second sheet and/or second excel and pass it to the Queue,
If someone can show me a workflow and also how to pass it to process state it will be really helpful
Add a Switch with the Int Type Arguments
Pass the expression as SheetCount
in he Case 1:
in the Case 2:
Give the bot to read and add the data of the other sheet.
You need to increment the SheetCount when the process is completed with Sheet 1
Use Above method if you want to process the sheet 1 first and then get the sheet 2 add them in queue and process them
If you want to add the data in the queue at a stretch (i.e., In one time)
Assign a integer
SheetCount = 1
Use For each
CurrentItem in Enumerable.Range(0,2)
If SheetCount =1
TRUE → Give the bot to read and add the data of the first sheet in the queue.
Assign SheetCount = SheetCount+1
FALSE → Give the bot to read and add the data of the Second sheet in the Queue.
Basically…in the get transaction data as I showed above you need to pass each sheet for each iteration…and in process xaml you will use in_TransactionItem argument value instead of the original sheetname…then for each iteration you will get a different name and process xaml will read different data…
Check the key name properly…Also may be its retreiving any old item i guess…check and use properly…you can check the transactionitem from the locals panel…also on queue filter on in progress when failed and check the content of that particular item…