I have a workflow I am working on where I am trying to use a Join tool to join the data based on a Return ID, but it doesn't seem to be working for some reason and I am stumped. I have successfully done a similar workflow with similar data, so I'm not sure what I am doing wrong in this instance. I have included the two data sets and the piece of the workflow below.
Thanks!
Solved! Go to Solution.
The problem is that Dataset 1 starts with 2017i whereas Dataset 2 starts with 2017I.
It's a fussy one. Case doesn't match in both fields. Drop a Data Cleansing tool after the data source 1, and change the Return ID to be Uppercase.
Cheers!
Esther
I wonder which is faster, the formula tool or the Data Cleansing?
Both do the same thing. Go with whatever you're more comfortable with.
Thanks y'all! I went with the Data Cleansing tool as you suggested. I didn't realize how finicky it was with case since I'm a bit of a novice. Appreciate your help!
Any time!!! Ask a question here, and you'll get lots of approaches to a solution.
If you wouldn't mind, marking our solutions as accepted is helpful for us, and for people seeking answers/seeking to help answer. Thanks!!!
Cheers,
Esther
@estherb47, I've always overlooked that box in the Data Cleanse tool!
I won't forget about it again!