Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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?




0 Replies