Question: I have a table with people and their hometown names, but there are same cities with different written, see:

| Name | Hometown |
| --- | --- |
| João | São Paulo |
| Maria | Sao Paul |
| Pedro | São Paulo. |
| Maria | S. Paulo |

And I need to process this in order to formalize that data to be like this:

| Name | Hometown |
| --- | --- |
| João | São Paulo |
| Maria | São Paulo |
| Pedro | São Paulo |
| Maria | São Paulo |

* The dataset has more than 2400 distinct values so I can't hard code.
* I have a Country table dimension with all cities and their correct names.

I tried [this stack](https://stackoverflow.com/questions/33433925/is-there-a-way-to-measure-string-similarity-in-google-bigquery#comment126356697_57499387) and would it be exactly what I need but does not work with my entire dataset.

Answer: 
I have no clue what's wrong here but below line is what causing the failure when i am trying to run `bzt script.jmx`

```
log.debug( vars.get("QUOTE_ID"));

```

To fix it when I changed `log.debug` to `log.info` it fixed the below problem I was facing. This is the partial answer as i am not sure about the reason for failure, but this should solve an issue where the script runs fine in Jmeter but bzt gives an error for XML parsing.

[![enter image description here](https://i.stack.imgur.com/mlxtr.png)](https://i.stack.imgur.com/mlxtr.png)
0. Wouldn't that be easier to add [BlazeMeter Uploader plugin](https://github.com/Blazemeter/jmeter-bzm-plugins/blob/master/sense-uploader/BlazeMeterUploader.md) to your JMeter test plan, the plugin can be installed using [JMeter Plugins Manager](https://www.blazemeter.com/blog/how-install-jmeter-plugins-manager/)
1. It's possible to [run existing .jmx script](https://gettaurus.org/docs/JMeter/#Run-Existing-JMX-File) without creating any YAML

```
bzt /path/to/your/test.jmx

```
2. The correct syntax to [define properties](https://gettaurus.org/docs/JMeter/#JMeter-Properties-and-Variables) is:

```
execution:
- scenario: simple

scenarios:
  simple:
    script: tests/jmx/dummy.jmx
    properties:
       quote.threads: 20
       #etc

```
3. Parameters can be passed via `-o` command-line argument[enter link description here](https://gettaurus.org/docs/CommandLine/#Command-Line-Options-Override)