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
Solved! Go to Solution.
Hi @maryjwitt
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,