Vlookup with multiple records

[bubblyjai1982]

Hi All,

Please help on below 

Using Find and Replace tool able to do Vlookup but if want to perform Vlookup with two or more records to match, how I can do.

Both input and output file attached

Thanks

[Bren_Spill]

@bubblyjai1982 - Based on the data provided it looks like you're matching data from two streams - can you use the Join tool instead of Find and Replace? You can join on multiple fields to get your matches and tag them as matched with a formula tool. Tag the records that don't match (L or R) as unmatched and union back together.

[bubblyjai1982]

Sorry this may not work for me !!

Let me reframe, I have a records which are not same as per input and output and I want to perform Vlookup function without disturbing the original records and with multiple different sheets one by one. In this case if i use join tool may not give original records with correct results.

Please find the latest input file and expected output

Appreciate if you could help with workflow 

Thanks

[Bren_Spill]

@bubblyjai1982 - can you provide your workflow?

[bubblyjai1982]

I'm new to Alteryx, would be great if you help on this problem.

I have attached my workflow.

[bubblyjai1982]

Hi All,

Can anyone please assist me with solution. I'm new to Alteryx would be thankful if you help on this .

Let me reframe, I have a records which are not exactly same i.e. Original record is with 10 refs and want to perform Vlookup with file which may not have all 10 refs. Hence If I use Join Tool will give the result of records which are common match.

And also I want to perform Vlookup function with multiple different sheets(records) one by one, without disturbing the original records and if i use join tool may not give original records with correct results.

Please find the latest input file and expected output

Appreciate if you could help with workflow

Thanks

[Bren_Spill · Accepted solution]

@bubblyjai1982 - Is something like the attached what you're looking to do? This approach creates duplicates as there are records in input 1 and 2 that have the same Name and Reset Date but different Reset Rates.

[bubblyjai1982]

Sorry was sick and couldn't respond back.

Yes please it is creating duplicate records but this is helpful and my query is resolved.

Thank you