Dear colleagues,
I’ve already tried two days to replace the counries’ names in my dataset…
For me it is not clear which node i need to use (i tried String Replacer (Dictionary) but i could not implement a Dictionary Table, which shall be conneted in the bottom part of the Note) and how imlement the folowing:
Column “Location” was splitted by me into several columns, but i’ve found meaning mistake when i read more accurate, e.g., Country is Russia, not the Russian Federation, or, more serious error, Company name is Roscosmos, but due to the fact that i splitted the location and there is Baikonur Cosmodrome, Kazakstan, inside the cellthe the Knime, of course, put into the column Country Kazakhstan instead the Russian Federation…
So, I have several errors:
'Russia' : 'Russian Federation',
'New Mexico' : 'USA',
"Yellow Sea": 'China',
"Shahrud Missile Test Site": "Iran",
"Pacific Missile Range Facility": 'USA',
"Barents Sea": 'Russian Federation',
"Gran Canaria": 'USA'.
I hope somebody of you have an idea how to implement it.
Thank you in advance.
Best regards,
Ekaterina