Having trouble in working with Excel

Help Activities
, ,
#1

Invoices.xlsx (11.4 KB)
result demo.xlsx (8.7 KB)
Hello Everyone! Can Someone please help me carry out my task. I tried a lot can’t get my desired output. Files are attached. Invoices.xlsx is the main file to work on and result demo.xlsx is my desired output. I group up the ClientNames, what is the workflow after that. Explained and detailed answers will the appreciated as I am new to RPA Journey. Thanks

Forum Engagement Daily Reports
#2

Hi @Zen_Ahmed ,

Can you elaborate your query.

Thanks,
Ashwin

#3

I actually want output as my result demo.xlsx from my Invoices.xlsx. I have no idea how to carry out the workflow.

#4

Hi @Zen_Ahmed ,

I have seen the excel files which you have provided, can I know on what basis your entering the values like from where are you retrieving InvoiceAmount & InvoiceCount

Thanks,
Ashwin

#5

Total_InvoiceAmount is the sum of all invoice of specific client like Units&Product Inc.
Total_InvoiceCount is the total number of invoices issued to a specific Client.

#6

Hi @Zen_Ahmed,

Based on the information, try the below idea

  1. Use Build Datatable, to create the required column
  2. Use For each row, create a datarow and assign the values.
  3. Create Add Datarow & add this datarow value.
  4. Use Write Range to write into the excel.

Thanks,
Ashwin

#7

HI @Zen_Ahmed

Here is the workflow

You can refer to the steps in the workflow
Invoices.zip (70.8 KB)

Hope it will solve your query

Regards
Sudharsan

1 Like
#8
  • I appreciate your consideration, help and time. Thank you soo much
#9

2
1
Can you please guide me to steps attached as pictures?

#10

That is for returning the number of invoice id in excel file

Regards
Sudharsan

1 Like
#11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.