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.
|
Nou pe simpatie:
ingera_31
 | Femeie
25 ani
Constanta
cauta Barbat
30 - 59 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 3 luni#1 |
TRaPModerator
Postari: 964
|
|
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])),
{".", ",", "-", " "} |
|
|
| |
|
