Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Try using the concat function.
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;
Hi,
Yu can try using concat function.
concat(F1,'|')
Regards,
Amay
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
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