Hey everyone,
I need to sort dates for each employee ID, and it should remain same after using it in any join condition also.
How can I acheive that? attached sample data.
Thanks in advance
hope this helpplease check your input i think you messed up with dates.
hey @Kavya132017
here is one way to do it:
Using a sort tool and sort by ID, Date, Role. Joins will sometimes resort so you may have to add the sort back in after the join.
In looking at your output, what are you sorting on? It looks like its Seniority? If thats the case you may need to add a reference key to rank the Senior manager down to Intern and use that as your sort method.
Try This.
