I am trying to create a lookup logic to load various columns in a table. I have a child table with customer details along with Revenue as a measure. Also customer has a location and I need to fill information related to the location by looking up in the master table. Customer can move from one location to another so Customer state might not be the same in both child and master.
I need to fill in missing Revenue details for customer - This is done by looking up Customer ID in the Master Table.
Similarly, I don't have Capital and Population details for some of the States in child table. This need to be filled in by looking up against the Master table by joining the State column alone.
There are records in child table which is not present in Master table but they have information available, so those records are ok. In the end I am trying to get all the missing information filled in the child table.
I have attached the workflow I am trying and I got Revenue part working and I am looking for options on how can I get the Capital and Population working in the same flow.
