I have two tables I want to create a join on using Social Security Numbers. Since this field is PII, after I connect to the data, I only want the last 4 digits of the SSN to appear. Is this possible?
Once you do the join I believe you should be able to create a calculated field using the Right() formula to grab the last four characters.
It should look like this: Right([SSN], 4)
You should then be able to drag that into your worksheet just like any other field.
Does that work?