This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi Experts,
I have a situation where iam getting the below data from a data source. i want to clean the data and populate it as good data. Please suggest me how we can handle this in alteryx.
obj id | address | address2 | region | state | country | |
1 | Nyherji | Kÿ¿ÿ¶llunarklettsvegur 2 | NULL | Reykjavik | NULL | Iceland |
2 | CANADIAN NORTH | 3731 â¿¿ 52 Avenue East | NULL | Edmonton | Alberta | Canada |
3 | Atotech Deutschland GmbH | Erasmusstraÿ¿e 20 | NULL | Berlin | NULL | Germany |
4 | PT. NTT Indonesia | Tower WISMA 46 â¿¿ KOTA BNI 5TH FLOOR | NULL | jakarta pusat | NULL | Indonesia |
5 | BELL TECHNOLOGIES | Carrera 7 No, 155 c â¿¿ 20 PISO 25 | NULL | Bogota | NULL | Colombia |
6 | Tauron Dystrybucja | ul. Dajwÿ¿ÿ³r 27 | NULL | Krakÿ¿ÿ³w | NULL | Poland |
7 | Tauron Dystrybucja | ul. Dajwÿ¿ÿ¿ÿ¿ÿ³r 27 | NULL | Krakÿ¿ÿ¿ÿ¿ÿ³w | NULL | Poland |
8 | Tauron Dystrybucja | ul. Dajwÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³r 27 | NULL | Krakÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³w | NULL | Poland |
9 | Tauron Dystrybucja | ul. Dajwÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³r 27 | NULL | Krakÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³w | NULL | Poland |
10 | Centrum Medyczne Puÿ¿awska Sp. z o.o. | ul. Puÿ¿awska 49 | NULL | Piaseczno | NULL | Poland |
Transpose into Rows grouping on Object ID. Then use formula tool and replace special characters with desired characters.