Edit the edit:
Solved the duplications as well.
I have solved the issue, but now, when I join the table based on the EMP_ID, I have duplications.
How can I avoid those?
I am trying to get all values related to the same ID.
For example I have employee id and end dates. EMP_ID is not unique in this table.
I would like to create a calculated columne with all end dates related to the same employee id (List_of_End_Dates),
How is that possible?
Solved! Go to Solution.