topic Re: how to read a table record by record in QlikView

how to read a table record by record

bumin — Sun, 21 Apr 2013 13:27:13 GMT

Hi experts,

I have the following problem for which I couldn#t find any solution.

from

Objects:

LOAD * INLINE [

100

200

300

];

I would like to generate the following string:

(100|200|300)

the inline table is just an example. The data is stored in DB table

tahnks for you help

Bumin

Re: how to read a table record by record

jolivares — Sun, 21 Apr 2013 22:43:49 GMT

Try using the concat function.

Re: how to read a table record by record

Mon, 22 Apr 2013 01:11:47 GMT

Hi try concat function..

Syntax is = concat(distinct(fieldname),'|')

or concat(fieldname,'|')

xyz:

LOAD * INLINE [

100

200

300

];

load concat(F1,'|') as ABC

resident xyz ;

drop table xyz;

exit script;

Re: how to read a table record by record

Mon, 22 Apr 2013 05:18:39 GMT

Hi,

Yu can try using concat function.

concat(F1,'|')

Regards,

Amay

Re: how to read a table record by record

bumin — Mon, 22 Apr 2013 05:37:11 GMT

thanks for the answers,

it took 10 hours to get the the question into the forum.

In the meanwhile I found it myself

concat(fieldname,'|') is the right answer

kind regards

Bumin

Re: how to read a table record by record

jolivares — Mon, 22 Apr 2013 12:59:08 GMT

Saludos Miguel Angel, hace un par de días hice un post con una requerimiento, crees que puedes revisarlo a ver si tienes alguna solución.

http://community.qlik.com/message/326737#326737