Different tabs & Different Sheets

Question

I have a data which looks like

I need that separate excel sheet  will create for each country and the file name should be the country name.

Then for each countries file female data will goes to tab Female and a separate tab for each point.

Please note that number of points may increase let say, USA can contain 2,3,4,5,6 and hence number of tabs will also increase or decrease accordingly.

Please help me to solve this.

Thanks in advance.

deepakshaw1991 · Answer

I need another help as below:-

I need to solve this urgently. Please help me

AncientPandaman · Answer

use formula tool + output tool

output tool - in the bottom that take file name from by field value. pick the change entire file path. pick the field create by formula below.

formula tool - create a path with this format [folder]\[filename].xlsx|||[sheet name]

i.e  c:\download\USA\.xlsx|||Female

example formula : "C:download" + [Country] + ".xlsx|||" + [Gender]