Splitting consolidated report into individual reports (with many underlying criteria)

Help Studio
, , ,
1

Hi UiPath experts,

My enquiry today is how can I split a consolidated report into individual reports with many criteria involved. I am able to do a simple loop to split the report in the past based on 1 or 2 criteria. However this time round, there are many criteria involved which I am stuck.

For reference, we can refer to my earlier topic here: (How to read ).

The steps required are listed below:

  1. Open Main Report_D981A.xlsx (19.9 KB), go to Cases_2 tab in the workbook.

  2. Copy Cell F2 from Cases_2 tab to “Appointment List” tab in Template v11.xlsx (1.2 MB).

  3. Find the Company’s Name (e.g. Company 1) first, copy the name into Cell A7 of the “Appointment List” tab.

  4. Copy the records under that Company (Column A to O, excluding the headers) until -Page Break-, paste into the “Appointment List” tab mentioned above (starting at A9).

  5. Read the “Record Type” header (Column B) and “Target Amount” header (Column K) in the “Appointment List” tab. There will be 3 types of scenario:
    a) If the record type is Appoint, to leave it in the “Appointment List” tab (i.e. Do nothing).
    b) If the record type is Released/Urgent Released, to check if there is target amount. If there is no target amount, to cut and paste these rows to “Release (No Target) List” tab.
    c) If there is target amount, to cut and paste these rows to “Release (With Target) List” tab.

  6. Arrange the S/No in all the 3 tabs so that the rows are in sequence.

  7. Create a folder with today’s date, and save the updated template in the folder. The name of the template will be the Company’s Name.

  8. Repeat step 2 - 7 (loop) so by the end of the script, if there are 11 companies in the Main Report, there should be 11 excel files in the folder with today’s date.

  9. To create an exception: If the Company’s Name is “Company X”, to use Company X Template.xlsx (1.5 MB) instead of the original template. The steps from 2-7 remain the same.

I tried to come up with a new workflow based on my previous post and other related posts, but I can’t seem to link them up correctly. Hope that someone here will be able to provide some guidance on this.

Thank you in advance.

2

Hello @WadeShon!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff