G
Guest
I have an interesting problem that I hope someone can help me with. (Note
that “interesting†is not always a good thing.)
Some well-meaning person set up automated data logging on a process in my
company. The resulting information, however, is very difficult to work with.
A “snapshot†is taken each half-hour of the status at each station. Each
line of data begins with the date and time, then a counter of the cumulative
number of units produced. Then there’s a pair of columns for each station,
with the station number in the headers (data in the field names! Aaargh!).
The first column is a (cumulative again) count of “incidents†at that
station, and the second is the (cumulative, of course) amount of time lost.
I think the way I want to see the data is to have a file with the date,
time, and units produced info. A second file would have date, time, station
number, incidents, and time lost.
The data is presented in a .CSV file. There’s about 70 stations, by the way.
Does anyone have a way of “de-pivoting†this data, so to speak? I’d rather
have individual values for each time period, instead of the cumulative ones,
too.`
It could be done in Excel and then imported into Access, or it could be
imported directly into Access if I could set up some routines to do it there.
Thoughts?
TIA,
Randy
that “interesting†is not always a good thing.)
Some well-meaning person set up automated data logging on a process in my
company. The resulting information, however, is very difficult to work with.
A “snapshot†is taken each half-hour of the status at each station. Each
line of data begins with the date and time, then a counter of the cumulative
number of units produced. Then there’s a pair of columns for each station,
with the station number in the headers (data in the field names! Aaargh!).
The first column is a (cumulative again) count of “incidents†at that
station, and the second is the (cumulative, of course) amount of time lost.
I think the way I want to see the data is to have a file with the date,
time, and units produced info. A second file would have date, time, station
number, incidents, and time lost.
The data is presented in a .CSV file. There’s about 70 stations, by the way.
Does anyone have a way of “de-pivoting†this data, so to speak? I’d rather
have individual values for each time period, instead of the cumulative ones,
too.`
It could be done in Excel and then imported into Access, or it could be
imported directly into Access if I could set up some routines to do it there.
Thoughts?
TIA,
Randy