Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
=concat({<$Table={'MyTableNameHere'}>}distinct $Field, ', ')
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);