Write Table names into one variable

[#1]

Hi,

I have the fields One, Two and Three in one Table and now I want to get this fieldnames into one variable in the qlikview script. How to do this? Is there a function like concatenate?

Thanks...

[Gysbert_Wassenaar]

=concat({<$Table={'MyTableNameHere'}>}distinct $Field, ', ')

[sunny_talwar]

May be this:

Table:

CrossTable (FieldNames, Data)

LOAD 1 as Temp,

  *;

LOAD * Inline [

One, Two, Three

1, 2, 3

];

FinalTable:

LOAD Concat(FieldNames, ',') as ConcatFieldName

Resident Table;

LET vVar = Peek('ConcatFieldName');

TRACE $(vVar);