Doing the Vlook up with Multiple column

harmful_virus · 2023-03-07T19:06:21+00:00

Hi Team, I have one static excel file (Refer below) . Static Data(We will be updating this static file manually if we have new customer details)Bank Account 1Customer IDSource IDCIF IDClient…

harmful_virus

Hi Team,

I have one static excel file (Refer below) .

Static Data(We will be updating this static file manually if we have new customer details)
Bank Account 1	Customer ID	Source ID	CIF ID	Client Name
1256	45898	147896	1256987	ABC
1478	54789	256236	2145878	PQR
1569	14569	125893	1458888	UVC
1256	14789	125478	3256987	BHJ
1748	14563	125469	2145889	KJUY
1458	14589	124785	1254789	BBh hhh

Now my requirement is - I have the below file & I want alteryx to perform vlookup the "Unique Identifier" in All the Above static column(Bank account 1, Cust ID, Source ID, CIFID) and if these are available in any of the column then give me the Client name as output Else BLANK

Input Data

Unique identifier

14569

125478

1254789

1748

45898

The below should be my output

Output Data
Unique identifier	Client Name
14569	UVC
125478	BHJ
1254789	BBh hhh
1748	KJUY
45898	ABC

Please Note: I dont want to use Append tool and make my Static data one below the another & perform the file & replace option. Please suggest me some simple tool to get my output

Workflow

Macros

Batch Macro

Iterative Macro

Accepted answers

binu_acs

@harmful_virus One way of doing this

Lookup_070323.yxmd

All comments

binu_acs

@harmful_virus One way of doing this

Lookup_070323.yxmd

harmful_virus

@binu_acs Thanks for your quick response. The above is just a dummy Data. I tried the same logic in my actual data but the records are getting duplicated & the Identifiers which are not availabe in static data is getting filtered out. I may require union tool to append the missing data which looks very confusing.

can you please help me with simple vlook up logic or macro - where my "identifier" should get looked up in multiple column of static data & give me the Client name as output data.

binu_acs

@harmful_virus I think it should work in your real data as well, would you be able to provide a sample input file with the duplicate values as well? It would be easy for me to work on that file

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703