This content has been marked as final. Show 3 replies
Hello, I have two data sources that I want to join. One of the sources comes from a oracle database and has a column named GAGE which contains Gage numbers that are of various lengths. The second data source is an excel file that has a column named GAUGE PREFIX which contains the prefix (first 4-5 letters of a Gage number).
For example from data source 1 I have:
And from data source 2 I have:
GAUGE PREFIX TYPE
I want to combine the sources to get a result like:
Anything will help. Thank You