Import data from a column to sheets

[Feras95p]

Dear all,

I have these data as shown in the picture below:

What I'm looking for is that, I want to create a workflow so  that when I use this data as an input excel file I want to have as a result each nationality with the names and age information in a separate sheet. For example in sheet 1 I will have the information for the Indian,sheet 2 for Turkish and sheet 3 for Italian.

Is that possible to be done by alteyx?

Thanks in advance for your kind support!  

[DavidP · Accepted solution]

You can do this by telling the Output data tool to use the field [Nationality] for the sheet name, like this:

[Rihan_Mohamed]

Hi Feras,

You can use the workflow attached below. Please note just change the output tool setting as mentioned in the below screenshot.

The output and workflow is also attached. hope this resolve your problem.

If this solves your issue please mark the answer as correct, if not let me know.

[Feras95p]

Thank you !

[Feras95p]

Thank you bro, it works great!