topic Re: Finding relation in sections entry in Talend Studio

Finding relation in sections entry

Prasanna3 — Fri, 10 May 2019 05:35:57 GMT

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.

Re: Finding relation in sections entry

manodwhb — Fri, 10 May 2019 06:03:31 GMT

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

Re: Finding relation in sections entry

Prasanna3 — Fri, 10 May 2019 06:22:20 GMT

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

Re: Finding relation in sections entry

manodwhb — Fri, 10 May 2019 06:58:04 GMT

@prasan , Please check the below one.

Re: Finding relation in sections entry

Prasanna3 — Fri, 10 May 2019 07:04:20 GMT

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

Re: Finding relation in sections entry

manodwhb — Fri, 10 May 2019 07:05:30 GMT

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

Re: Finding relation in sections entry

Prasanna3 — Fri, 10 May 2019 07:11:20 GMT

Hi

Thanks for the solution.

Let me try this once with my actual data..

Re: Finding relation in sections entry

Prasanna3 — Sat, 11 May 2019 05:10:04 GMT

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

Re: Finding relation in sections entry

manodwhb — Sat, 11 May 2019 16:31:53 GMT

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

Re: Finding relation in sections entry

Prasanna3 — Sat, 11 May 2019 17:27:20 GMT

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

Re: Finding relation in sections entry

Prasanna3 — Mon, 13 May 2019 05:19:38 GMT

Hi,

Any solution?