field value concatenation

[demoustier]

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

[Gysbert_Wassenaar · Accepted solution]

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

];

[Anonymous]

You can use concat:

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

[demoustier]

Magique !!!!!

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

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