variable in dimension name

[M_Jay]

Hi,

I have few dimension fields with similar names in the data table like field1, field2, field3... field11.

How do I list all these columns values in one list? Is there any for loop in set expression?

Thanks

[ajaykakkar93]

Hi,

Use $Field in dimension you will get list of all fields in all the tables

[anat]

concatenate all the fields in backend script as a single field

like

load field1 as newfield from source

concatenate

load field2 as newfield from source

[M_Jay]

Hi Ajay,

The exact field names are Project1, Project2, Project3,...., Project11. Can you give me the exact syntax for set analysis? I don't understand how to use $ in the dimension name.

Thanks

[marcus_sommer]

Your data-structure is a crosstable which could be easily transformed into normal records, see:

The Crosstable Load - Qlik Community - 1468083

[ajaykakkar93]

Hi,
Hope it helps