Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

demoustier
Contributor

field value concatenation

Good day QViewer !

I have a list of unique value:

F1

a

b

c

d

e

f

....

and i'd like to have a unique value = "a"|"b"|"c"|"..."

I tried with previous, Peek, loop,....without any success.

If somebody have an idea.....

Kind regards

1 Solution

Accepted Solutions

Re: field value concatenation

Try concat(chr(34) & F1  & chr(34), '|')

Example:

LOAD concat(chr(34) & F1  & chr(34), '|') AS List INLINE [

F1

a

b

c

d

e

f

];


talk is cheap, supply exceeds demand
3 Replies

Re: field value concatenation

Try concat(chr(34) & F1  & chr(34), '|')

Example:

LOAD concat(chr(34) & F1  & chr(34), '|') AS List INLINE [

F1

a

b

c

d

e

f

];


talk is cheap, supply exceeds demand
mov
Esteemed Contributor III

Re: field value concatenation

You can use concat:

chr(34) & concat(distinct F1, chr(34) &'|' & chr(34)) & chr(34)

demoustier
Contributor

Re: field value concatenation

Magique !!!!!

Thank you very much !!!!!!!!!!!!!!

PS: now, i have to spend some time to understand this formula

Community Browser