Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fetch most recent by date and process

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.

 

Labels (2)
1 Solution

Accepted Solutions
vboppudi
Partner - Creator III
Partner - Creator III

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.

0683p000009LwsX.png0683p000009LxEJ.png

Regards,

 

View solution in original post

3 Replies
vboppudi
Partner - Creator III
Partner - Creator III

Are you looking for the following output?0683p000009LwoC.png

 

Regards,

Anonymous
Not applicable
Author

Veeru,

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

 

Appreciate your help.

vboppudi
Partner - Creator III
Partner - Creator III

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.

0683p000009LwsX.png0683p000009LxEJ.png

Regards,