Empty rows filling using other reference coloum

Question

Hi,

i have two scenario, my main object to fill the  External city blank from Internal city by using reference.

1st Scenario

i have only one internal row, with using ref column i want to bring the city to external row

legValueCityrefExternal2 253External3 253External1 253Internal6Chennai253

2nd scenario

i have two internal line by using ref column and value, i need to bring the city to external, like for Chennai we have value 4 for external any number which sum to 4 i need to give Chennai and remaining I need to give Delhi

legValueCityrefExternal2 253External3 253External1 253External1 253Internal4Chennai253Internal3Delhi253

kindly help how to achieve this using Alteryx

binu_acs · Answer

@Anbumani but if you take 3+1 it would give you 4 as well , that means External 3 also fall in Chennai I guess?

Anbumani · Answer

@binu_acs Like the red highlighted i need the output

legValueCityrefExternal2Chennai253External3Delhi253External1Chennai253External1Chennai253Internal4Chennai253Internal3Delhi253

binu_acs · Answer

@Anbumani Can you provide the expected result for scnario2 for better understanding?