I am plotting cities and its operator on the map. One city has more than one operator so I concatenated the operators against the city.
When I select geo_city I can see operators in that city.
But I when select m_operator I cannot see they are present in which cities. Since geo_city and geo_m_operator(this is concatenation of m_operator) are connected but geo_city and m_operator are not connected (above screenshot)
Let me know how to fix this.
You can also let me know if you have some other approach to display city and all its operators in different way so that fields city and operator are connected.
Your table with the m_operator field isn't connected to the rest of the data model...I understand you want to be able to chose a city and see connected operators and chose a operator and see connected cities?
Could you try with this in your script and then maybe you can add the mapping part to it?
Upper(m_city) AS MobileCity,
Upper(m_operator) AS MobileOperator,
release AS Release
(biff, embedded labels, table is Sheet2$)
Where m_city <> Null();
MobileCity&': '&Concat(MobileOperator,' ,') AS CityOperator,
MobileOperator&': '&Concat(MobileCity,' ,') AS OperatorCity
Group By MobileCity,MobileOperator;
Drop Table Temp_Table;
// Not sure about the mapping part below //
LET noRows = NoOfRows('City_Operator')-1;
FOR i=0 to $(noRows)
LET City =Peek('MobileCity',$(i),'City_Operator');