If a PM having only Planned rev not actual rev then show actual rev as 0, without duplicating the values of planned rev, vise versa.Īnd also if a PM exist in planned rev but not in actual rev then those PM's also should be in list, and show the values of actual and planned rev accordingly what they have.
When i tried inner join i get only the matching rows from both tables, that means if a PM exist in Planned rev table but not in Actual rev table then i dont get that PM in merged table.And i got the same values as above image I would like to get a merged table like, there will be no data loss, and there will be no data duplicating. I dont understand why i am getting these values.
So when i am using full outer join it gets all rows from both tables.īut it giving soo wrong values like as in below imageīut actual no is $1.47. And Some of the PM's Exists in planned rev,not in actual rev. I have two tables, one is Planned Revenue and another one is Actual Revenue.I would like to merge these two tables based on PM(For ex) using Full outer join.īut I have the tables data like Some of the PM's having Planned Rev but not Actual Rev, And some of the PM's having Actual Rev,but not Planned Rev. advancedfilterstuff.png 27 KB resultadvancedfilterstuff. Unless you have saved it within OneDrive or SharePoint, which do the versioning automatically. I have been searching and trying to findout a perfect solution for merging two tables without missing any data from both tables and without duplicating the values but i could'nt get anywhere. There is no Excel tool whitch does know without versioning, which one of your duplicate rows is the latest saved one.
0 kommentar(er)
