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.
