knowing the missed values

Anonymous — Sat, 23 Mar 2019 11:42:44 GMT

i'm beginner in talend and i have a problem

i have two query

the first query returns values like (code) : 1 , 2, 4 ,7 etc

and the second query returns 1 String (code_grille_talend) : 12345697

in my job i would know the missed value from the query 1 in the string

exemple : in this exemple the missed value is 3

i have used tjavaFlex but i don't have result . i need ideas for this job

thanks

Re: knowing the missed values

fdenis — Tue, 26 Mar 2019 07:53:41 GMT

hi

you have to use tmap to catch reject join.
first format all your data in the same type.
then have a look at https://help.talend.com/reader/8BHX9tH5qcw~5xM6p58OTg/7VFow3bHpC71W~iGA3oYnA

regards.