I have a situation that seems complex, or at least it feels complex to me. I have a layer for administrative divisions, and initially, this layer contained only one field to determine the type of administrator (boundary_en). All types of divisions were in this single field. Now, I’ve decided to separate each type of division into its own field. So, instead of having (District, Sub-District, etc.) in one field, I plan to create a field for (District) and a field for (Sub-District).
The issue I encountered is that I can't populate the data correctly. Each Sub-District belongs to a District, but I'm unable to match them accurately. For example, if District 1 has Sub-Districts 2, 3, and 4, I need the District value to be repeated as 1-2, 1-3, 1-4 for each Sub-District. However, I'm struggling to do this. I’ve attached a snapshot to illustrate the problem more clearly.
By the way, I used the "Join Attribute by Location (Intersect)" tool, but it gave me incorrect results, like assigning different Districts to the same Sub-District.
I hope this clarifies the issue.
sample file here https://we.tl/t-2oFgAm1jz5
