valuelookup for filtered table

Dear all,

I have a big table coming out of a database

With valuelookup from dictionary table I add several new columns to the data table

Then datatable is written back to database

But I only want some records from datatable to be processed with vlookup.

So I have to filter datatable before using vlookup

But how can I realize that the complete datatable with all records from inbound is written back to database under the below listed conditions:

  1. datatable contains all records as from inbound

filtered data with the addtional record and unfiltered data

  1. order of the records is identicle to dictionary table from inbound

Thanks for help!

BR,

Heinz