Forum Discussion
Filling in a Table with Intermittent Dates
Let me clarify - do you mean you'd like to generate the table as in Oak Hill Data sheet from the bunch of added from time to time files like Wing XXX Load, syncing resulting data by datetime?
That is correct. The full monthly calendar in Oak Hill Data would be populated according to the incomplete dates in the data sheets, hopefully.
I see, thank you. Format/structure of the source files is exactly the same as in sheets, or you modified them somehow?
I don't know how to check the minor going ons behind the scenes in Excel, but the format of both dates fields should be mm/dd/yy hh:mm, sampled every 15 minutes.
I mean more data structure
- is each source file have only two column?
- is datetime always in first column and data in second or they could be shifted?
- are columns headers same for each file or they could be different?
- If different for sources when are they they same for monthly files for the same source?
- is there any naming convention for file names?
- are time intervals the same for all sources (starts from 00:00 with every 15 minutes if not skipped, or that could 00:10, 00:25 as well, etc.)