Hi everyone,
I have a question and I apologize if this is an easy solution. I have two files and I need to join based on two fields. For example
Field1 (In File 1) Field 5 (In File 2)
123456 L123456-Test Case ABC
I need to join based on the common values within both fields. In this case, '123456'.
Would I need a regex expression to remove the other characters from Field 5 (In File 2)? If so, not sure how to write that expression.
I would really appreciate any help to find a solution. Thank you so much!
Solved! Go to Solution.
Please see below:
I used a Regex tool in order to get 6 digit from Field 5 (In File 2)
Then I used the join too based in the extract field.
Attached the workflow,
Hope this helps,
Regards,
Thank you! This worked perfectly!