Add a set of data to an exisiting excel file

[ErikH]

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

[JoshKushner · Accepted solution]

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.

[ErikH]

Thanks!