I want count of total no. of transaction written in separate excel

Help Studio
1

I want to know of all combined transaction is run every single time.

For eg

image

I want the count of all the count in separate excel.

Transaction Count
4.
This second excel will be password protected as well
So that we will know who was run the process how many times.

2

Hi @Bhushan_Nagaonkar

  1. Use read range activity to read the excel and store in an DataTable.
  2. To get the count of No. of rows in the excel use the syntax:

DataTablevar.RowCount / DataTablevar.Rows.Count

Print it using an writeline activity or message Box.

Hope it helps!!

Regards,

1 Like
3

Im using reframework. How should I use for RE-Framework

4

If you’re using RE Framework,
Your transaction type would be of type DataRow,

You can write the count in the Final State or in the Init State itself by reading the range from the input Source File.

1 Like
5

can you share the flow?

If Im not wrong

I have to assign value to Transaction Item ie Datarow.Count

6

You can put it here in End Process like this:

image
image517×764 17.4 KB

h

7

I dont want to overwrite it should append

8

Can you share your expected output?

And sorry my bad in the second write cell it should have been A2 as Cell

9

Hi @Bhushan_Nagaonkar

Instead of using Write Cell try using Append Range to append the data.

Hope it helps!!

Regards,

10

The process will be run n number of times.

For eg
On Day-1
3 transactions
Day 2
4 transactions

So it should append.

11

Keep your excel file at some shared location.
Use Build Data Table : dtRecords with one column TransactionCount
add Data Row : Pass {dt_TransactionData.rowCount.toString} in ArrayRow and in dataTable: dtRecords.
Use Append Range activity to add records one after the another.

My suggestion would be to add a second column while Building DataTable with TransactionDate
in Add Data Row you should pass {dt_TransactionData.rowCount.toString, Now.ToString(“dd/MM/yyyy”}

Thanks
Aditya

1 Like
12

I do need second column for name who has used the script.

Thankyou for your time and efforts. I’ll check and let you know

13

@adiijaiin Can you share your workflow. im making some mistake

14

Hi @Bhushan_Nagaonkar ,

which UiPath version are you using?

I did share a xaml before was that opening?

If so I can edit and reshare.

Thanks,
Aditya

15

hi @Bhushan_Nagaonkar

I have modified the workflow and attaching for your reference along with the output generated:
testdata.txt (1.4 KB)
CustomerData.xlsx (7.5 KB)
JSONData.xaml (13.9 KB)

16

I will just check and let you know,

Thanks

17

Im using 2023 latest

18

hi @Bhushan_Nagaonkar

Did you check this workflow?

19

You built a data table for it, you stored the value.

In this way we can use for reframework as well. I just have to increase the count

20

Yes,

we can do it.

Hope this has helped you out.

Regards,
Aditya

1 Like