This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking for an easier and more concise way of doing this.
I have incoming data from 2 sources which look more or less similar, however the dates in Input-1 are slightly off whereas the dates in Input-2 are correct. However, I want to have all the combinations of Employee ID and dates from both the sources in the final output except for the ones which have same employee ID and same month or the difference between the dates in both the sources for same employee ID is within 1 month of each other. In such cases, I would like to keep the record which is as per input-2 and not as per input-1