Looking for a way to partially join 2 inputlookups.
Lookup 1: username, name
jsmith, John jdoe, Joe
I would like to return a match on jsmith to jsmith-sa but have not been able to figure out how to partially join. ie search for jsmith* against lookup2 not for exact matches. The 2nd lookup may have the entire keyword or keyword-something Search returns:
... View more