Rows reduces after inner join

KBH

Hello 

The input file is a hierarchal  structure, I have 176765 records 

My output result with self-join ( L, J, R) =166441

 my client wants the same input number = output number which is impossible to do ?

How can I explain to him the lines are not reduced but they have been put as right fields?

Thank you in advance 

Khaoula 

atcodedog05

Hi @KBH 

There is a possibility of R output + J output > R in this case there might one-to-many joins happening i.e 1 row of R can be joined with more than 1 row of L this way the number of rows might increase. Refer below.

Hope this helps : )

Join.yxmd