Loading columns/fields with dynaminc names into new table

Anonymous — Tue, 25 Sep 2018 06:38:45 GMT

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!

Re: Loading columns/fields with dynaminc names into new table

Gysbert_Wassenaar — Tue, 25 Sep 2018 06:50:33 GMT

Are you perhaps looking for the CrossTable load?