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?
Thanks a lot in Advance
Hi @goektug.oezer ,
Please refer this xaml:
JoinTables_2.xaml (7.1 KB)
Sample input and output:
Data.xlsx (12.2 KB)
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?
I have given the output as per the table in above image. Now tell me what is your expected result.
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.
Data.xlsx (11.6 KB)
JoinTables_2.xaml (7.2 KB)
Got it. Xaml Updated. test it.
I haven’t realised that, one “inner” solved our problem ^^
I’m so appreciated you are helping me.
Thanks a lot again @kadiravan_kalidoss
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.