knowing the missed values

[Anonymous]

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 

[fdenis]

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.