String Replacer (Dictionary)

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

I have solved the problem, using the following approach (pipeline): String Replacer (Dictionary) with Table Creator Node (putting there the required data to be changed) on the bottom part (bottom connector), and my Data Set on the top part (top connector). The settings are presented in the pic attached to this reply.
2024-10-10_21-16-02



3 Likes

Hello @Felis90,

Thanks for sharing the images for the solution to the problem and posting an update!

TL

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.