I need to merge 2 different table based on one particular column - GEID . The 2 excel table is given below
If you could observe the order of rows are different when you try to match with “GEID” column apart from Row 1 . I use “Join Data Tables” to merge table to get expected output
But output I received was something like this
What i found was only first row is merged remain all rows are not merged but added as new row, since I used “Full” join type.
Could you please suggest how can i join when row order is different