Automatically Generate Field Names to Load

joey_lutes — Fri, 31 Aug 2018 16:09:45 GMT

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?

topic Automatically Generate Field Names to Load in App Development

Automatically Generate Field Names to Load