How to match different name format

Hi,

I wish to perform a VLOOKUP function to lookup the 'full name' between two input files but their names are not in the same format. Can Alteryx make the two names the same format?

Regards

Doug

Different name format lookup.xlsx

Tips and Tricks

Accepted answers

binay2448

Find attached my solution it will help you.

How to match different name format.yxmd

All comments

binay2448

Find attached my solution it will help you.

How to match different name format.yxmd

DouglasEKL

Thank you very much, it solves my issue.

binay2448

@DouglasEKL, Please mark it as solution it will help others for similar issue

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335