Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
joey_lutes
Contributor

Automatically Generate Field Names to Load

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?




Tags (2)