community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Add a set of data to an exisiting excel file

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
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.

Meteor

Thanks!

Labels