Output in multiple tabs

griseldagomes

Hello Experts,

I have the below set of data where I am looking to segregate the data into separate sheets on the same file (colours in this case).
I started with the formula tool to categorize them with relevant tags (colour) and then used multiple filter tools considering there were more than 2 types of colours and finally used the block until done tool prior to connecting them to the same output file. However, the results are not displaying as expected. Could you please advise how can I get this done.

Also is there a way to sequence the tabs in the output file as per one's requirement?

Date	Quality	Fruit/Vegetable	Colour
01-May	High	Apple	Red
02-May	Medium	Orange	Orange
03-May	High	Grapes	Green
04-May	High	Watermelon	Red
05-May	Low	Mango	Yellow
06-May	Medium	Pineapple	Yellow
07-May	High	Kiwi	Green
08-May	Medium	Potato	Brown
09-May	Low	Tomato	Red
10-May	High	Spinach	Green

TABS:

Red

Orange

Green

Yellow

Brown

Yoshiro_Fujimori

Hi @griseldagomes ,

Output Data tool can be configured to meet your requirement.

Output Data tool configuration

Use "Change Entire File Path" option.

To feed the file path to Output Data tool, you need to edit it with Formula tool beforehand.

Expression in Formula tool

Path = ".\Colors.xlsx|||" + [Colour]

Result Window

Output Excel sheets

As you see the result window and the output excel sheets, it seems the Sheets are ordered in alphabetical order.

So if you want to order in a different way, you may need to add prefix in the sheet name (e.g. 1_Red, 2_Yellow, 3_Green, etc.)

I hope this helps.

Colors.yxmd