Loading columns/fields with dynaminc names into new table

[Anonymous]

Hello QV Experts!

I am trying to load into table field from other table, where name of columns are definefd by variable.

So we have in one table columns with year&month:

then I made loop to catch all columns from "Source_Table" and put them into "Base" table

for i = 1 to 16 //we have 16 columns to check

    let Name = FieldName($(i),’Source_Table');

         Left join(Base)

     load
          Plant,
          Material,
          $(Name) as $(NowYear)$(i)
          Resident Source_Table;

next i

But as result I got:

Any ideas how to import all values instead of only field names?

Thanks!

[Gysbert_Wassenaar]

Are you perhaps looking for the CrossTable load?