Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
lonely_32 pe Simpatie.ro
 | Femeie
24 ani
Valcea
cauta Barbat
26 - 57 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 931
|
|
If you have a company name entered in different ways but essentially referring to the same company, e.g. ABCDEFG S.A. and ABCDEFG SA and ABCDEFG S.A and Abcdefg Sa etc., since merge query is case sensitive, you would need to first normalize the occurrences.
The unique values query might have ABCDEFG SA, so you could normalize only the main query.
If both queries have a different value than let's say an upper name without punctuation or extra spaces, then you should normalize the columns in both queries:
= Text.Remove(
Text.Upper(Text.Trim([Company Name])),
{".", ",", "-", " "} |
|
|
| pus acum 11 zile |
|