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:
datatable contains all records as from inbound
filtered data with the addtional record and unfiltered data
order of the records is identicle to dictionary table from inbound
Hi @Heinz , if my understanding is correct, you want to write back all rows, regardless of whether they are included in the update?
If you filter the database before you are doing the value lookup, then perhaps for your filter you can use a Row Splitter, or Rule Based Row Splitter. You would then perform the Value Lookup on the subset from one port of the Row Splitter and then after the Value Lookup, you could concatenate the result of the Value Lookup with the other port of the Row Splitter
To ensure the same order as the original table, you could include a Counter Generation node before the splitter, then use this to sort after the Concatenate and then make sure you remove the counter with a Column Filter:
e.g.
