Compare two data tables having 2 common columns and write values accordingly

[Swara_Soni (Swara)]

In the excel file Match.xlsx (10.7 KB),
The input sheet Sheet1 looks like
The sheet having values Sheet2 looks like

The required output sheet output looks like

Here, When column “Quality and Series” of Sheet1 matches with column “Quality and Design Series” of Sheet2 then Assign Column A,B,C,D of Sheet1 values like A of Sheet1 = (Pro * A of Sheet2) and so on for other columns also where round the digits of output upto three decimal places.

Please help…

[raj.parsana (Raj Suresh Parsana)]

Hello @Swara_Soni,

You can use Merge datatable activity :-

Merge Data Table

Thanks & Regards,
Raj parsana

[Swara_Soni (Swara)]

@raj.parsana…Thanks for reply… but by using merge datatable activity i can’t create the required output as i want the Pro column to multiply in the output sheet.

[ppr (Peter Preuss)]

@Swara_Soni
Find starter help here:
Swara_Soni_MatchProFactor.xaml (7.5 KB)

[Swara_Soni (Swara)]

@ppr Thanks a lot for the solution.