This image shows an example of hierarchical lookup consisting of following three steps:
Step 1: State=Arkansas, Country=Canada, CityCode=KN_USA
Step 2: State=" ", Country=Canada, CityCode=KN_USA
Step 3: State=" ", Country=" ", CityCode=KN_USA