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
Solved! Go to Solution.
Thanks, ithe key is untick "Keep Field in Output".
Cheers