Sort Dates For Each employee

[Kavya132017]

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

[Raj]

hope this help

please check your input i think you messed up with dates.

[gautiergodard]

hey @Kavya132017 

here is one way to do it:

[cjaneczko]

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. 

[cjaneczko]

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.

[cjaneczko]

Try This.