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)…
