I have a table that is over 2 million records froem a text file and I think, but not sure that the best way to relate fields is to create column and insert the relating paramters in a row in a new column A.
I am able to sort the file so that everything Below the FY20XX relates to the column with FY in it. So when the FY20XX changes then everything below that row relates to the FY20XX row. Is there a macro or visual basic or function that can be used to populate the column so that I can relate the fields below it using the text from B to E?
I'm thinking of creating blank column and maybe run update query to populate that column with the relating text.
A B C D E
"FY2012""Load_Actual""Prelim""ZA70010" "FY2012" "Load_Actual" "Prelim" "ZA70010"
"FY2012""Load_Actual""Prelim""ZA70010" "APZ" #Mi 1892.517 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "RFZOUT" #Mi 292.72942 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51000" #Mi 1214.09399 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51030" #Mi 124.18024 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51050" #Mi 0.19638 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "FTE" #Mi 24.57461 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "Account" 7 7 7
"FY2013""Load_Actual""Final""ZA70010" "FY2013" "Load_Actual" "Final" "ZA70010"
"FY2013""Load_Actual""Final""ZA70010" "RFZIN" #Mi 293.15942
"FY2013""Load_Actual""Final""ZA70010" "APZ" #Mi 1892.517
"FY2013""Load_Actual""Final""ZA70010" "51000" #Mi 1603.24352
"FY2013""Load_Actual""Final""ZA70010" "CNL" #Mi 0.2114
"FY2013""Load_Actual""Final""ZA70010" "FTE" #Mi 17.2
"FY2013""Load_Budget""Prelim""ZA70010" "FY2013" "Load_Budget" "Prelim" "ZA70010"
"FY2013""Load_Budget""Prelim""ZA70010" "RFZIN" #Mi 292.72942 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "APZ" #Mi 1892.517 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "51000" #Mi 1301.70703 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "51030" #Mi 119.91203 #Mi
I am able to sort the file so that everything Below the FY20XX relates to the column with FY in it. So when the FY20XX changes then everything below that row relates to the FY20XX row. Is there a macro or visual basic or function that can be used to populate the column so that I can relate the fields below it using the text from B to E?
I'm thinking of creating blank column and maybe run update query to populate that column with the relating text.
A B C D E
"FY2012""Load_Actual""Prelim""ZA70010" "FY2012" "Load_Actual" "Prelim" "ZA70010"
"FY2012""Load_Actual""Prelim""ZA70010" "APZ" #Mi 1892.517 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "RFZOUT" #Mi 292.72942 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51000" #Mi 1214.09399 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51030" #Mi 124.18024 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "51050" #Mi 0.19638 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "FTE" #Mi 24.57461 #Mi
"FY2012""Load_Actual""Prelim""ZA70010" "Account" 7 7 7
"FY2013""Load_Actual""Final""ZA70010" "FY2013" "Load_Actual" "Final" "ZA70010"
"FY2013""Load_Actual""Final""ZA70010" "RFZIN" #Mi 293.15942
"FY2013""Load_Actual""Final""ZA70010" "APZ" #Mi 1892.517
"FY2013""Load_Actual""Final""ZA70010" "51000" #Mi 1603.24352
"FY2013""Load_Actual""Final""ZA70010" "CNL" #Mi 0.2114
"FY2013""Load_Actual""Final""ZA70010" "FTE" #Mi 17.2
"FY2013""Load_Budget""Prelim""ZA70010" "FY2013" "Load_Budget" "Prelim" "ZA70010"
"FY2013""Load_Budget""Prelim""ZA70010" "RFZIN" #Mi 292.72942 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "APZ" #Mi 1892.517 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "51000" #Mi 1301.70703 #Mi
"FY2013""Load_Budget""Prelim""ZA70010" "51030" #Mi 119.91203 #Mi