I am pulling in data from an Excel file on a Sharpoint.
In QV I am doing an incremental load as the Excel file will have that days data and I need to build history.
I need to capture a time (during the load) when the file is put on the SharePoint so I can configure a Traffic Light Gauge based on the time the file is loaded to the SharePoint.
<12:00= Green
>12:01 & <2:00 = yellow
>2:01 = Red
I have tried FileTime, but it updates the entire FileTime column to the current Load Time.
Is there a way for it to retain the FileTime if there is data already in that field and only update the FileTime if the FileTime field is blank for that record?
Dan
Here is an example of what I need:
| DATE | DIFFERENCE | FileTime |
| 4/4/15 | $0.00 | 4/4/2015 14:05 | New FileTime |
| 4/4/15 | $0.00 | 4/4/2015 14:05 |
| 4/4/15 | $0.00 | 4/4/2015 14:05 |
| 4/4/15 | $0.00 | 4/4/2015 14:05 |
| 4/4/15 | $5,954,275.15 | 4/4/2015 14:05 |
| 4/4/15 | $4,954,275.15 | 4/4/2015 14:05 |
| 4/3/15 | $6,954,275.15 | 4/3/2015 18:00 | retain old filetime |
| 4/3/15 | $0.00 | 4/3/2015 18:00 |
| 4/3/15 | $0.00 | 4/3/2015 18:00 |
| 4/3/15 | $0.00 | 4/3/2015 18:00 |
| 4/3/15 | $0.00 | 4/3/2015 18:00 |
| 4/2/15 | $0.00 | 4/2/2015 13:00 |
| 4/2/15 | $0.00 | 4/2/2015 13:00 |
| 4/2/15 | $0.00 | 4/2/2015 13:00 |
| 4/2/15 | $0.00 | 4/2/2015 13:00 |
| 4/2/15 | $0.00 | 4/2/2015 13:00 |
| 4/1/15 | $1.00 | 4/2/2015 12:00 |
| 4/1/15 | $2.00 | 4/2/2015 12:00 |
| 4/1/15 | $3.00 | 4/2/2015 12:00 |
| 4/1/15 | $4.00 | 4/2/2015 12:00 |
| 4/1/15 | $5.00 | 4/2/2015 12:00 |
| 4/1/15 | $6.00 | 4/2/2015 12:00 |
