How to match two tables with different rows?

Help Studio
, ,
1

Now I have two excel files,they all have three sheets, and sheets name are same.
Table1：image
Table2：

image
image796×367 11.4 KB

When the value of column A in TABLE1 is the same as the value of column D in TABLE2 and the value of column B in TABLE1 is consistent with the value of column C in TABLE2, it indicates a match.The result i want to output to a new excel file with same sheet names.

Please tell me how to do these, thanks a lot!

Best Regards!

2

hi joon,

can you please send test files.

the comparision should be done for table 1 cht sheet and table2 cht sheet likewise for remaining sheets you should perform same comaprision and get matching records in second table correct.

Thank you.

3

Hi,
FYI
demo.zip (42.4 KB)

Thank you

4

hi joon,

are the sheet names fixed in two excels?

Thank you

5

Hi，
yes.

6

ok thank you

7

Hi，
I use get workbooks sheets to get sheets names,but they are usually fixed in three and correspond in order.

Thanks!

8

Hi joon

Attaching work flows here and output is stored in output.xlsx

please check and let me know

Thank youdemo.zip (46.3 KB)

1 Like
9

Hi,
This is awesome！It worked. What if I want to add other related columns to the exported OUTPUT TABLE, add other columns in TABLE 2 to the OUTPUT TABLE, and add a new column that matches or does not match. If there is no match, the missing data need not be written.

Thank you so much!
Best regards.

10

Hi joon

can you be more clear on what columns you want in output.xlsx.

Thank you

11

@Joon612
have a look on this activity

a typically flow pattern would be

  • readin in Excels
  • do Join
  • do filter columns the join result
  • write back to Excel

in case of more complex scenario we do have the options to look on other activities or to do with LINQ

1 Like
12

Hi，
If it matches, I need"Langue|Vendor|Category(AKA ParentFolderName)|ImageName(AKA SubFileName)" in TABLE 2 column, and “Whether matched|FullPath(=Langue+Vendor+Category)”. If it doesn’t match, I just need the “Imagename” and “whether matched” All columns need to be in the table, but can be left blank, header order is not fixed。

Best Regards!

13

please send me output file sample with matched or not matched scenarios along with columns.

Thank you

14

Hi,
FYI

image
image1588×281 16.1 KB

Ignore background style，almost like this.
(Ps:File extensions are not required for values ​​in column ImageName，just like the OUTPUT table now)

Best regards!

16

demo.zip (51.0 KB)

1 Like
17

Hi,
It worked.Thank you very much for your help.I was really touched.

Best Regards!

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.