- Posts: 58
- Thank you received: 0
Dealing with multiple records
8 years 11 months ago #11558
by amathur
Dealing with multiple records was created by amathur
Hi,
I want the following transformation to be done. Input(example attached) has multiple records with respect to "ID". What I want in output is selecting one record corresponding to each ID based on latest "Date of Joining". Another condition is if there is "Date of Retirement" present then select the record which is having latest "Date of Retirement".
Desired Output based on Input is attached.
I want the following transformation to be done. Input(example attached) has multiple records with respect to "ID". What I want in output is selecting one record corresponding to each ID based on latest "Date of Joining". Another condition is if there is "Date of Retirement" present then select the record which is having latest "Date of Retirement".
Desired Output based on Input is attached.
Please Log in or Create an account to join the conversation.
8 years 11 months ago #11562
by admin
Mike
ETL Architect
Replied by admin on topic Dealing with multiple records
This can be implemented by using sorter and grouper.
See pictures attached.
See pictures attached.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
