Dear Experts,
We want to validate the hierarchy data, if any of the N-1 (lower-level) hierarchy data is missing in the column.
hierarchy level is separated by a "-" dash. Could you Pls guide me on how to achieve this?
Can you please be a little more specific on what you mean by 'missing hierarchy' data? I'm assuming you mean that, for example, BOOCRN2-E000-PD15 is missing 2 rows of data above it:
BOOCRN2
BOOCRN2-E000
If this is the case, I would recommend attaching a recordID to each row by using a recordID tool, and then splitting to rows based on the '-' delimiter by using a text to columns tool. Then you can use a Multi-Row formula tool to generate a 'hierarchyID' which can be used to check the original data for the correct hierarchy values. I've attached a lazy PoC which can be adapted to suit your needs as necessary (e.g. add an iterative macro instead of checking each length individually)
by a "-" dash. Could you Pls guide me on how to achieve this?
