I have 2 tables:
Master:
Thing, Value
aux1, 4
aux2, 9
aux3, sometext
aux4, moretext
pri1, hello
pri2, 8
pri3, 9
pri4, donuts
PriList:
//This table is created by pulling FieldName(Thing), then parsing that fieldname to create the Field_Ref field WHERE Thing starts with 'pri'
Field_Name, Field_Ref
pri1, 1
pri2, 2
pri3, 3
pri4, 4
I want to a table that automatically generates the Field_Name list in the load statement, based on the Field_Name from the PriList table, and which pulls VALUE from the MASTER table based on all rows in the PriList Field_Name.
End result:
//loop through Field_Name in PriList, populate those in the following load statement:
Pri_Value:
Load
pri1,
pri2,
pri3,
pri4
Resident Master;
Drop Table Master;
I've tried several types of loops, researched LookUp, but the solution continues to elude me.
Ideas?