Finding relation in sections entry

[Prasanna3]

I have data like below table how do I maintain relation between section and parentid ?
sectionid parentid code codesystem
708 0 NULL NULL
709 708 123 1.2
710 709 NULL NULL
711 709 NULL NULL

For ex: As per below table if sectionid 709 need to find all parentids with 709 and if parentid 709 available then need to check code and codesystem values null or not . if null get the values from sectionid 709 and update those values into parentid 709.

can someone guide me how can I achevie this in talend.

if not understand please let me know.

[manodwhb]

@prasan , if possible can you provide required output also?

[Prasanna3]

Hi

Thanks for quick response.

Output should be like this.


sectionid parentid code codesystem
708 0 NULL NULL
709 708 123 1.2
710 709 123 1.2
711 709 123 1.2

[manodwhb]

@prasan , Please check the below one.

[Prasanna3]

Data is from db and will it work for if many parent ids repeated also

[manodwhb]

@prasan ,yes it will work, but you need to have data what you have provided in the way.

[Prasanna3]

Hi

Thanks for the solution.

Let me try this once with my actual data..

[Prasanna3]

thanks for your solution,it works fine for me
But i need one more solution,As per your solution it was updating where sectionid 708 and parentid 708 records also
i don't want to update that ,please find below screenshot

can you please provide me solution for the below one.

Capture780.PNG

[manodwhb]

@prasan ,why cannot you filter record which you wan to do the join?

[Prasanna3]

Yes we can,but I need to load that record also without updating those
values.

For ex:sectionid 708 values don't want to update in parentid 708.is there
any alternative way to do in Tmap same as you did.

Thanks,
Prasan