I have a city that is showing up on the wrong state.
I have a city that is showing up on the wrong state. For example i have customers in Hollywood CA & Hollywood FL. Though when I select FL on the map, Hollywood CA shows up on the point map. Please Help !
Re: I have a city that is showing up on the wrong state.
Here are screenshots, I've also loaded the auto script that Qlik created. As you can see, I selected Florida as the state and Hollywood as the city, though its putting it as California. There is no way to geotag the city to the state.
Set dataManagerTables = '','CustTest';
//This block renames script tables from non generated section which conflict with the names of managed tables
For each name in $(dataManagerTables)
Let index = 0;
Let currentName = name;
Let tableNumber = TableNumber(name);
Let matches = 0;
Do while not IsNull(tableNumber) or (index > 0 and matches > 0)