Output to a standard template with multiple excel files?

[znooredeen004]

See the attached file.

Originally I had a problem where I wanted to split the text to column by delimiter and needed to line up to record position. This community was able to help me solve this issue so everything lined up correctly and I was able to export John to one excel file then Debra to a separate excel file.

Name:        State                  Income              Subincome           

John            Alabama             4132                  132

John            Arizona               5100                  452   

John            New York            2004                  654

John            Georgia              10400                128

Debra          Alabama             4020                  858

Debra          Arizona               5234                  562   

Debra          Connecticut        2100                  125

Debra          New York           10000                 222

Debra          Georgia              1520                   321

The issue I'm having now though is i need the same states for each person even if one person has more. So basically even though John does not have Connecticut, I want it to show the same states for each person so for John it'll also include:

Name:        State                  Income              Subincome           

John            Alabama             4132                  132

John            Arizona               5100                  452   

John            New York            2004                  654

John            Georgia              10400                128

John            Connecticut         0                        0     (this could also be blank if absolutely necessary)

Debra          Alabama             4020                  858

Debra          Arizona               5234                  562   

Debra          Connecticut        2100                  125

Debra          New York           10000                 222

Debra          Georgia              1520                   321

Do I need to have a separate template for it to write to with the same states? BUt then I also need alteryx to export to multiple excel files based on name like i described before.

Sorry if this is confusing but any help or clarity would be appreciated!

[fmvizcaino · Accepted solution]

Hi @znooredeen004 ,

Attached is an example showing how to do it.

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

[znooredeen004]

@fmvizcaino This helped me learn a lot! Thank you. My original file has about 100,000 rows but it looks like for the most part everything went through and an even amount of rows came out with each out put.

Thank you so much again!