Joining two tables but not getting expected output, PFB attached screenshots for clear picture

Help Studio
, ,
1

Hi Everyone, I’m facing an issue while joining Two tables, I am attaching input tables, what output I’m getting and what output i want. i have used full outer join, please help me to the solve the issue.
Table1
Table2

The output i want
The output i want769×178 3.72 KB

The output Im getting
The output Im getting769×289 4.5 KB

2

@bharti.balasahebgodse

try with inner join

image

hope this helps

3

Hii @bharti.balasahebgodse

Use this Linq Query

(
From a In DT1
Join b In DT2
On a(“Name”).ToString Equals b(“Name”).ToString
Select DT3.Rows.Add({a(“Name”),a(“Code1”),a(“Group1”),a(“Age1”),b(“Code2”),b(“Group2”),(“Age2”)})
).CopyToDataTable

Cheers…!

4

@bharti.balasahebgodse

Welcome to the community

The output you need is not possible with join even if you try to join on name as each row is not having data only few rows are having it…

Try to have name in eqch row then we cna join…but even then how do you identify which row goes to what row…looks like you are preserving the order of rows

Please provide an excel file with multiple data not only for one name…and the expected output ot see the combinations possible

Cheers