Possible Issues with Joint Grandparent and Parent Rows
Situation: : If a a base row has a grandparent row that is a joint but the parent row is not, then when checking for unexpected files, the sibling IDs will be generated based on the parent row, which is not a joint, and therefore the sibling IDs will not include the joint variable. This can lead to missing sibling IDs and therefore missing expected files when checking for unexpected files.
Task: Need a way to check if any of the ancestor rows are joints and if so, generate sibling IDs based on the joint variable instead of the parent variable.
Possible Issues with Joint Grandparent and Parent Rows
Situation: : If a a base row has a grandparent row that is a joint but the parent row is not, then when checking for unexpected files, the sibling IDs will be generated based on the parent row, which is not a joint, and therefore the sibling IDs will not include the joint variable. This can lead to missing sibling IDs and therefore missing expected files when checking for unexpected files.
Task: Need a way to check if any of the ancestor rows are joints and if so, generate sibling IDs based on the joint variable instead of the parent variable.