Search for similar field values, replace and remove duplicates
I'm working on a project where categories have been saved with similar names multiple times. An issue which should have been fixed at an earlier stage, but cannot be done.
here's an example of values that should all be named "Solumstrand"
As there is quite a lot of these mistakes, i would like to give a column of correct names which should be (wild?)matched with the faulty names and replace them.
I have attempted like this for joining and i suppose i can remove the faulty names in a new load statement
//Names i want to correct to Prosjekttabell: Load Prosjektnavn; LOAD Prosjektnavn INLINE [ Prosjektnavn 'Solumstrand', 'Muusøya', 'Kim Karlsen' 'Sande', 'Svelvik' 'Elvika', 'Lier', 'Linnes', 'Mjøndalen', 'Vidar Hansen', 'Åsgårdstrand' ];
//I want to search Prosjekt for substrings found in Prosjekttabell and join the fitting name to all the correct rows join (Prosjekttabell) Load distinct PROSJEKT_ID, PROSJEKT_NR, PROSJEKT Resident 'Drammen_test' where WildMatch(PROSJEKT, [Prosjektnavn])= [Prosjektnavn];
I get the error message "Cannot find the field name Prosjektnavn"