How to compare two different matched Excel Data Table to merge

Help Studio
, , , ,
1

I’d like to compare two table from two different sheet in the same excel. First table has 5 Column and second one has only 3. What I want to do is, I wanna compare 4th Column in first table with 1st Column in the second table. If there is match, write on third sheet in a new table as 6 Column. I manage to bring 5 Column but last one has no match with first table, so can’t bring it in.

Is there any chance if someone help me what do I miss?

First
2
3

Thanks a lot in Advance

2

Hi @goektug.oezer ,

Please refer this xaml:
JoinTables_2.xaml (7.1 KB)

Sample input and output:
Data.xlsx (12.2 KB)

Thanks!

3

Hi @kadiravan_kalidoss ,

Thanks a lot for your work. But it brings all unmatched data from sheet one underneath of our data table. Any chance not to bring them in?

4

Hi @goektug.oezer,

3

I have given the output as per the table in above image. Now tell me what is your expected result.

Thanks!

5

hey @kadiravan_kalidoss ,

I only would like to have matched data to write in Sheet3. Basically I don’t want to have reds in. That would be unrelated data for my result to report.

1.jpg

Data.xlsx (11.6 KB)

6

JoinTables_2.xaml (7.2 KB)
Got it. Xaml Updated. test it.

Thanks @goektug.oezer

7

I haven’t realised that, one “inner” solved our problem ^^
I’m so appreciated you are helping me.

Thanks a lot again @kadiravan_kalidoss

1 Like
8

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