|
Database Help
I have 7 individual CSV files that are for 7 months of data. I want to combine them into one CSV file. The individual files contain data,number. Not all indivdual files have the same data or first field so I need to be able to compare the first field and output the number for each second field.
Tough to explain but here's a little example.
June
data1,56
data2,78
data9,72
July
data1,87
data2,67
data7,52
Etc.
Would like the output formatted like.
data1,56,87
data2,78,67
data9,72,0
data7,0,52
Anyone that can give me a hand or write me something? ICQ 265054864
__________________
erik AT suthnet.com
|