Grouping Data into separate reports

Question

Hi Everyone

I am trying to produce separate reports from an input data in the sample format as attached. The challenge i am facing is trying to group the report into separate excel reports based on a field(let's call that business unit) in the sample data.

The outputs would be the same name as the business unit and in the same format .  The challenge lies in producing formatted outputs , the table beginning in a specified cell range . The sample data is the raw input and the 8100H and 8400A are the expected output files.

I have been browsing the community for solutions but no luck so far, can anyone provide some guidance.

Sample.xlsx

8100H.xlsx

8400A.xlsx

Emil_Kos · Answer

Hi @Skapoor1,

I am not sure how to easily achieve this and I think it is quite complicated tasks. What do you have on mind saying formatting options?

Those requirements can be handled with using a template?

Skapoor1 · Answer

Hi @Emil_Kos

Is there any way i can format this data in table tool  and then produce this as different files . I understand when we use table tool it has to be accompained by other report tools. I have some formatting requirements .Afterwards i would also need to append the data in the top left corner in all the files.

Emil_Kos · Answer

Hi,

If you will format them as numbers before saving the files you will have them in the number format. If you will use data cleansing tool in order to clean the puncation you should be able to change the data to double format.

That doesn't work for you?

If the issue is regarding the header you can create a separate workflow that will create you clean inputs files like this using the same logic as I have done.

Afterwards you would need to append the data using the workflow that I have shared with your earlier.

It isn't straight forward a solution so please let me know if this was helpful.