topic Write Table names into one variable in QlikView

Write Table names into one variable

Fri, 01 Apr 2016 13:00:34 GMT

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...

Re: Write Table names into one variable

Gysbert_Wassenaar — Fri, 01 Apr 2016 13:03:56 GMT

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

Re: Write Table names into one variable

sunny_talwar — Fri, 01 Apr 2016 21:45:54 GMT

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);