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
Solved! Go to 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.
Thanks!