Struggling with a Join

Hello! I'm trying to complete a very simple join of two string fields and for some reason I CANNOT get it to to work. The field from the first file is created from a RegEx parse, so in case that was causing any issues, I used the formula tool to complete a new field for joining. I also used the formula tool in the second file just in case. I am creating each as a V_String field with a length of 18, and also running through the data cleansing tool to replace nulls in the string fields, and removing whitespace, modifying to uppercase. This continues to result in 0 records returned. Any insight would be much appreciated! C

Oppty Workflow Clean.yxzp

Join

Accepted answers

Your Normalized Oppty ID field has a length of 16 characters, while your Join Header field (on the right side) has a length of 18.

I think you're missing some characters while you're doing your Parsing.

Cheers,

All comments

Your Normalized Oppty ID field has a length of 16 characters, while your Join Header field (on the right side) has a length of 18.

I think you're missing some characters while you're doing your Parsing.

Cheers,

Oh my gosh - YES! It was in the RegEx where I needed to add another 15 characters and not 13. THANK YOU so very much!

Change your REGEX tool (Parsing step) to this:

(006\w{15}) - Instead of 13, to 15.

You'll get 765 records out of your J anchor.

Cheers,

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703