Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bumin
Contributor II

how to read a table record by record

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

1 Solution

Accepted Solutions
Not applicable

Re: how to read a table record by record

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;

5 Replies
jolivares
Valued Contributor

Re: how to read a table record by record

Try using the concat function.

Not applicable

Re: how to read a table record by record

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;

Not applicable

Re: how to read a table record by record

Hi,

Yu can try using concat function.

concat(F1,'|')


Regards,

Amay

bumin
Contributor II

Re: how to read a table record by record

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
Valued Contributor

Re: how to read a table record by record

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

Community Browser