Hi Amelia.
I’ve seen your file. As I said before, open text fields are very difficult to manage.
I asked you a question. Are they all addresses from the UK? Let’s assume that, so they will all have the same format.
The format is supposed to have 5 fields separated by a coma. For some reason not all of them come correctly written.
Many are missing. If the Street is missing, we can’t do absolutely anything but inventing data. So discard those with the street missing. Other fields can be uncompleted, but not the street. Imagine somebody tells you, we’ll meet tomorrow at ‘no street’. Would you go to the appointment?
House or Street Numbers can be identified cause they’re numbers.
Since it can be a London area and a London street, we can’t do absolutely anything.
The postal code or ZIP, has a clear format. That’s CAP CAP NUM SPACE CAP NUM NUM. If you have a map of ZIP – TOWN, you can figure out the town for every zip. You may wan’t to have a street mapping but street names are repeated in different towns. Look for the funcktion mapping. They are web pages showing all this maps and they are easy to read with QlikView itself.
So, with all this reasoning, get to your help page, look for string funcktions and construct your script.
If you use a chart, you must set it up to see everything. In your chart, null areas don’t show anything. Add a dimension like street.
You can add those comas missing and then reload the table again.
Good luck.
