Multiple Data Vlook Up and Deduction

[SH_94]

Hi Community,

Currently i am trying to vlookup from multiple source of data and performing some calculation on the data. Below is the screenshot that i facing the issue. I knew how to vlookup from another single source by using join tools. May i know how can i build the workflow if i have so many data file to vlookup with? Could anyone guide me on this or share the samples of workflow? I also attached the file below for your reference.

Many thanks in advance. 

[shreyanshrathod · Accepted solution]

Hi @SH_94 ,

The JOIN MULTIPLE tool from Join palette should be able to help you here.

Check it out.

Regards,

Shreyansh Rathod

[Qiu]

@SH_94 
Just gave a try.