Get Data from Queue items using Refremework

[Shyam_Pragash]

Hi…

i have working in Reframework using to do the rpa challenge Challenge No.1

All the process are working fine without any issue in the code…

My requirement…

1. i have to create a datatable in the queue items and one more columns added at the end of the columns Columns Name (Status) and fille the status one by one…

2. How to this columns in Reframework and write it in excel sheet.

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
In Process Transaction State there is Set Transaction Status Workflow there you will get Success Condition. There you will have to keep write cell Activity and and Keep this file and Provide counter in Cell it will work,

Thanks

[Shyam_Pragash]

Hi @Rounak_Kumar1

ok…
can you explain in details… To understand better

Success means write the cell “Done” it on status columns (D+in_Tras+2).

How to add the queue items value ?

Thank
Shyam

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
You can follow this workflow

Thanks

[Shyam_Pragash]

Hi @Rounak_Kumar1

i understand this above you said…

above screen shot data in queue… i have to get back to excel sheet as show as image…
(queue items —> excel )

How to add the all queue data in excel sheet.

Thanks
Shyam

[Shyam_Pragash]

Hi @Rounak_Kumar1

i have sent status report to all .so that i want create this output.

if you know explain me…

Thanks
Shyam

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
Follow this

TransactionItem.SpecificContent(“FirstName”).ToString
Where FirstName is key in Queue Item

Thanks,
Rounak

[Shyam_Pragash]

Hi @Rounak_Kumar1

Which State i have to write this code ?

can you tell the position.

Thanks
Shyam

[Rounak_Kumar1 (Rounak Kumar)]

In Process Trnsaction State

e

Thanks

[Shyam_Pragash]

Hi @Rounak_Kumar1

Thanks You.,…

Let’s check and update you…

Thanks
Shyam

[Shyam_Pragash]

Hi @Rounak_Kumar1

i single line of output only.

See the final output

it stored only last queue items.

Thank
Shyam

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
keep the Build data Table Activity outside because its is taking new Data table every Time. It will work.

Thanks

[Shyam_Pragash]

Hi

outside means

where i place build data table ?

already create datatable i used.

i think this may create a issue

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
Keep in first Run of Intialisation State
make the Argument and make it Out direction then it will work

Thanks

[Rounak_Kumar1 (Rounak Kumar)]

Hi,

Did you get the output? Please let me know

Thanks

[Shyam_Pragash]

Hi @Rounak_Kumar1

Just Now i got expected output…

Thanks
Shyam