-
variable column names
I'm working on a data collection application. Actual device names to be logged can change. Two tables are used: a log "header" table that contains an entry with input descriptions (one record per "run") and another table that contains logged data every 10 seconds
Log header table:
DT | run_num | input1_desc | input2_desc |
| 1234 | inlet_temp | zone_1_temp
Data table:
DT | run_num | input1 | input2 |
| 1234 | 12.234 | 45.675
How can I create a view to show data with actual column names (ex: inlet_temp)? Or should db be re-designed?
-
Here is what I have:
LogHeader table:
DT | RUN_NUM | INPUT1_DESC | INPUT2_DESC |
XXXXX| 12345 | INLET_TEMP | OUTLET_TEMP |
Data table:
DT | RUN_NUM | INPUT1 | INPUT2 |
XXXXX| 12345 | 23.345 | 45.355 |
XXXXX| 12345 | 13.345 | 65.355 |
XXXXX| 12345 | 43.345 | 25.355 |
XXXXX| 12345 | 23.485 | 35.355 |
What I want: VIEW OR REPORT TO LOOK LKE THIS
DT | RUN_NUM | INLET_TEMP | OUTLET_TEMP |
XXXXX| 12345 | 23.345 | 45.355 |
XXXXX| 12345 | 13.345 | 65.355 |
XXXXX| 12345 | 43.345 | 25.355 |
XXXXX| 12345 | 23.485 | 35.355 |
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|