Using Joiner, Left Unmatched Rows, Yielded Red ? Mark

Hello Everyone!

I’ve been doing some research on my issue and exploring various solutions.

The case, input excel sheet with a log, input excel sheet with a “dictionary” of values, join the test type from the dictionary file to the log and filter out the specific test type. Here is what the sample data looks like:

Log

Dictionary

Posing an example using the data outlined above, in theory the join should show that SS1, LV2, etc… are NONTESTS. No matter what I do and which approach I take I don’t get the right result.

Thanks for all your help in advance!