topic How to dynamic SQL query in Talend Studio

How to dynamic SQL query

Anonymous — Fri, 15 Mar 2019 09:53:56 GMT

i try a job by a dynamic query who return the code_grille who contain all condition

exemple:

i have create a query who return the code_grille who contain all condition

code_grille :1234 like '%1%' and like like'%2% etc

now if there a false clause "where like"

i need choose the greatest code_grille who return the maximum of condition "likes" (not all)

this is my job i the first part

ideas please!

akumar2301 — Mon, 18 Mar 2019 10:42:24 GMT

Not Very clear .

Can you please explain with example ?

fdenis — Mon, 18 Mar 2019 10:58:21 GMT

I think You are looking for dynamic query.
do you know how to use global Map?
and tmap lookup for each row?
Regards