Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Write Table names into one variable

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

2 Replies

Re: Write Table names into one variable

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


talk is cheap, supply exceeds demand

Re: Write Table names into one variable

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

Capture.PNG

Community Browser