Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Add a set of data to an exisiting excel file

Highlighted
7 - Meteor

Hi,

I have an excel file with these values:

 

SKU | WEEK | MONTH | YEAR 

 

 

I'd like to generate a new row where I add a new sett of values from a store list

 

Stores:

- Texas

- Ohio

- New York

- Miami

- Florida 

 

 Original result:

SKU | WEEK | MONTH | YEAR | 

SKU1 | 02 | January | 2018 

SKU2 | 02 | January | 2018 

 

The wanted result would be:

SKU | WEEK | MONTH | YEAR | STORE

SKU1 | 02 | January | 2018 | New York

SKU1 | 02 | January | 2018 | Miami

SKU1 | 02 | January | 2018 | Ohio

SKU1 | 02 | January | 2018 | Florida

SKU1 | 02 | January | 2018 | Texas

SKU2 | 02 | January | 2018 | New York

SKU2 | 02 | January | 2018 | Miami

SKU2 | 02 | January | 2018 | Ohio

SKU2 | 02 | January | 2018 | Florida

SKU2 | 02 | January | 2018 | Texas

 

I've tried to use "generate rows" but havn't succeded 😐

 

Best Regards

Erik

Highlighted
12 - Quasar

Hi @ErikH, you want to use the 'Append Fields' tool. Input a table with your cities either manually in a text input or from a source file in an input data tool. Append the cities to your existing data (target = existing data, source = cities). This will get the result you want.

Highlighted
7 - Meteor

Thanks!

Labels