How to obtain rows from file and db with same id

[Anonymous]

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

1

2

3

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

[nfz11 · Accepted solution]

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