Hi Alan

In your query you have not taken into account the code for child

I have a big dataset where we have multiple combination of parent and child codes

thanks