append lookup value that are not match

[NadhirahAli]

I have a question on value lookup.

I have two Excel files: a Data Table with 3,000 rows and a Dictionary Table with 500 rows. After performing a lookup, only 300 rows from the Dictionary Table match. I want to append the remaining 200 unmatched rows to the bottom of the Data Table (starting at row 3,001), resulting in a total of 3,200 rows. How can I do this?

[rfeigel]

Try this. You’ll need to modify to match your data types and column names. You want to concatenate not append.
append lookup value that are not match.knwf (75.0 KB)

[NadhirahAli]

Thank you. That is what i imagine. Thanks a lot!