J
Janis
I import an Excel sheet weekly into a table called Port History. From Port
History I append that to the HSIRouterImport table after I scrub the data.
I will only append the new router rows for future weeks. It is data on
the router. The problem is I need to add only the 98thPercentile figures for
each weekending plus the new router rows. I don't know how to do this. I
need to only import that one column weekly? But how do I add each weekending
column to my HSIROuterImport table.
Do I need to copy the 98th Percentile column to a data table and create a
relationship based on date and the router fields? Or do I need a table for
each weekending? So do I create a new query based on this HSIROuterImport
table and the new query? I think I need a variable for the weekending dates
but I don't know how to structure this.
Please help,
tia,
History I append that to the HSIRouterImport table after I scrub the data.
I will only append the new router rows for future weeks. It is data on
the router. The problem is I need to add only the 98thPercentile figures for
each weekending plus the new router rows. I don't know how to do this. I
need to only import that one column weekly? But how do I add each weekending
column to my HSIROuterImport table.
Do I need to copy the 98th Percentile column to a data table and create a
relationship based on date and the router fields? Or do I need a table for
each weekending? So do I create a new query based on this HSIROuterImport
table and the new query? I think I need a variable for the weekending dates
but I don't know how to structure this.
Please help,
tia,