ETL Join by "Contains" function
When Joining in ETL, Is there a way to join by a "contain's" option?
For Example - I am Joining by part number, however one set of data contains a revision level.
So I have (A) 47100-15000 & (B) 47100-15000-A
This is common throughout the dataset, is there any way to set the join when matching (A) & (B) to join when (B) contains (A)?