Discussion Board for collaboration related to QlikView App Development.
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');
load Plant, Material, $(Name) as $(NowYear)$(i) Resident Source_Table;
But as result I got:
Any ideas how to import all values instead of only field names?
Are you perhaps looking for the CrossTable load?