Not sure how to describe this.
Say I have one file that contains a list of stores.
Another file that contains product.
I need to combine the two, so that the product duplicates below each of the stores.
With the store being it's own row.
So it's like a cross between a Union and Append tool.
Store - Input 1
Store1_NAME
Store2_NAME
Store3_NAME
Store4_NAME
Product - Input 2 (this is already a CSV file)
123*Orange*16
234*Blue*02
345*Red*32
Would look like this:
Store1_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store2_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store3_NAME
123*Orange*16
234*Blue*02
345*Red*32
Store4_NAME
123*Orange*16
234*Blue*02
345*Red*32