topic Re: Fill the Previous Record value in Current Record based on Max_year in Talend Studio

Fill the Previous Record value in Current Record based on Max_year

Vijay_K_N — Sat, 16 Nov 2024 02:41:38 GMT

Hi,

I have scenario like this

s_id,year,branch

10,1,ECE

10,2,

11,3,CSE

11,4,

Output will be

s_id,year,branch

10,1,ECE

10,2,ECE

11,3,CSE

11,4,CSE

Find the student max year id based on s_id and pass the previous branch value to the current branch

give me suggestions???

manodwhb — Tue, 14 Apr 2020 09:32:57 GMT

@lli , in tmap you create a variable filed do the below way.

row1.branch ==null?Var.branch: row1.branch

row1.branch

Vijay_K_N — Tue, 14 Apr 2020 10:00:35 GMT

I mean pass the branch value for maximum year of student id

manodwhb — Tue, 14 Apr 2020 10:12:06 GMT

@lli , take the variable fileds for branch and s_id and do the below way .firdt sort the data on S_id ans then use tmap and implement below logic.

row1.S_id==Var.S_id && row1.branch ==null?Var.branch: row1.branch

Vijay_K_N — Tue, 14 Apr 2020 10:31:21 GMT

not getting the desired output

see the screen shots

input:

s_id,year,branch
10,1,ece
10,2,null
11,3,cse
11,4,null

i want to pass the branch value if student year id is maximum

manodwhb — Tue, 14 Apr 2020 10:35:27 GMT

@lli ,can you move dow var1 and var2 after var3.

Vijay_K_N — Tue, 14 Apr 2020 10:38:01 GMT

ya but same result