How to obtain rows from file and db with same id

Anonymous — Fri, 10 May 2019 08:37:19 GMT

hello, i have a problem

i have a file csv and a table and i woold obtain rows that hava the same id both in dv and file.

for example in file

i have column

COD_PDR

in table row i hava column

COD_PDR;ID_sTRUMENTO

1; xx

5;ttt

so i have to obtain only 1 that is in ID file and in ID table row.

i have used tinputfile and toracleBd and with map but i obtain all rows without any filter

Where is error?

thanks

Re: How to obtain rows from file and db with same id

nfz11 — Fri, 10 May 2019 09:31:59 GMT

Change your Join Model to inner join, that should fix it.