Hi,
I am working with a very large list of loans (around 20,000) and need help with coming up with logic. Each loan is under a 'parent' facility where the facility plus all loans under it have the same top level code, but different low level (child) codes, and you know what the parent code is by the top level and low level codes being the same. For example, I could have a group of loans where:
Top Level: Low Level:
0001 0001 --> Facility
0001 0011 --> Loan
0001 0012 --> Loan
0001 0013 --> Loan
And if one of the codes within this group has a certain feature I want it assigned to the facility since the facility will always have this feature NULL. For example:
Top Level: Low Level: Code:
0001 0001 NULL
0001 0011 NULL
0001 0012 NULL
0001 0013 A
Want to look like:
Top Level: Low Level: Code:
0001 0001 A
0001 0011 NULL
0001 0012 NULL
0001 0013 A
I was thinking possibly of the Make Group tool but not sure if that would accomplish what I'm wanting.
If anyone has any ideas that would be great!
Thank you.
