how to read a table record by record

[bumin]

Hi experts,

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

from

Objects:

LOAD * INLINE [

    F1

    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

[jolivares]

Try using the concat function.

[#3 · Accepted solution]

Hi try concat function..

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

or concat(fieldname,'|')

xyz:

LOAD * INLINE [

    F1

    100

    200

    300

];

load concat(F1,'|') as ABC

resident xyz ;

drop table xyz;

exit script;

[#4]

Hi,

Yu can try using concat function.

concat(F1,'|')

Regards,

Amay

[bumin]

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

[jolivares]

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