Multipule output to csv with dynamic file names (No file name within the final extract)

[Gavin_FBu]

Hi,

I am trying to extract the output into multi csv files.  The output file is for us to do a data upload to our operation system (very old system) hence it required certain formnat for the csv file.

To make it easy, I have trimmed out a lot of columns.  Let say the final table only has 3 columns as below:  

Store Code	Product Code	Ratio
146	23207	18.9
167	23201	5.61
167	23261	5.95
167	23778	5.82
191	20786	5.91
191	20760	4.1
191	10472	5.33
191	1012	5.06
363	10124	5.51
363	10124	9.2

Requirement:

1.  Seperate data by store code and extract each store's data into different csv that named by the store code.
     In this example I required 4 csv files  that belong to each store (146.csv, 167.csv, 191.csv, 363.csv).  

2.   Each csv file only contain the data belong to the relavent store in the format =  comma seperatred value.

3.   (Here is the part I do not know how to) Each csv take away the title and remove Store Code column.  So each csv file only gives Product Code and Ratio.  It shoul look like the following for 191.csv

20786,5.91
20760,4.1
10472,5.33
1012,5.06

The table has approx 80 stores and I have no idea how to deal with it?  Hopefull I do not not need to write an excel macro to make that happen.

Cheers

Gavin

[fmvizcaino · Accepted solution]

Hi @Gavin_FBu ,

Is this what you are looking for? Example attached.

Best,

Fernando Vizcaino

[Gavin_FBu]

Thanks, ithe key is untick "Keep Field in Output".

Cheers