topic Re: concatenate all fields in a given column in QlikView

concatenate all fields in a given column

Fri, 02 Aug 2013 16:22:29 GMT

I'm trying to display the procedure source code from a database.
The problem I'm having is that the database is giving me the source code line by line.
So I currently have something like this..

Name line text

A            1         start
A            2         begin
A            3         blahblahblah
B            1         start
B            2         end

So for example, if I select A
I want it to show in a text box formatted as:
start

begin
blahblahblah

while if i select B:

start

end

Any method would be awesome.

Is there anything i can do maybe even in the script so i can only get

Name Text

A start (newline) begin (newline) blahblahbalh
B start(newline) end(newline)

Thanks!

Re: concatenate all fields in a given column

Gysbert_Wassenaar — Fri, 02 Aug 2013 16:28:28 GMT

Try concat(distinct [Text], chr(10))

Re: concatenate all fields in a given column

Fri, 02 Aug 2013 16:32:01 GMT

it doesn't seem to be in order

Re: concatenate all fields in a given column

Gysbert_Wassenaar — Fri, 02 Aug 2013 16:34:01 GMT

If the line field determines the order: concat(distinct [Text], chr(10), line)