This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If I understood correctly you want to see, if ACCOUNT_PCN column matches with the beginning of ACCOUNT column. I built a workflow that uses Find and Replace tool to check if ACCOUNT_PCN matches with the beginning of ACCOUNT (Find method is picked as Beginning of the field). Then with join tool the left outers are the account numbers from DATA.xlsx that don't match, joins are the ones that match and right outers are account_pcn numbers from DataPCN that don't match. This should work as long as the account numbers are unique in each file.