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
I actually want output as my result demo.xlsx from my Invoices.xlsx. I have no idea how to carry out the workflow.
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
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.
Hi @Zen_Ahmed,
Based on the information, try the below idea
- Use Build Datatable, to create the required column
- Use For each row, create a datarow and assign the values.
- Create Add Datarow & add this datarow value.
- Use Write Range to write into the excel.
Thanks,
Ashwin
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
- I appreciate your consideration, help and time. Thank you soo much
Can you please guide me to steps attached as pictures?
That is for returning the number of invoice id in excel file
Regards
Sudharsan
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.