topic Fetch most recent by date and process in Talend Studio

Fetch most recent by date and process

Anonymous — Thu, 24 May 2018 15:32:05 GMT

Hi,

Could you please tell how to design and implement following scenario?

I need to fetch most recent 4 records(based on Created Date) for every OppID and map those Category values to Category1,Category2,Category3,Category4.

I have attached file delimited below.

Re: Fetch most recent by date and process

vboppudi — Thu, 24 May 2018 16:59:01 GMT

Are you looking for the following output?

Regards,

Re: Fetch most recent by date and process

Anonymous — Thu, 24 May 2018 17:58:32 GMT

Veeru,

Yes Correct Could you please let me know how to do it.

Appreciate your help.

Re: Fetch most recent by date and process

vboppudi — Thu, 24 May 2018 18:30:45 GMT

HI,

Job flow is like screen shot i provided in previous post.

First convert createDate from string to date using tMap.

By using tSort sort data based on PorID and createDate.

Create sequence for each ProID and filter records >4. Means you are going o consider on first four records for each id.

Using tMap create 4 new fields.

Regards,