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.
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]
I need another help as below:-
I need to solve this urgently. Please help me
