Merging Keywords in Concept Trees

[Tobias Langer]

Dear Mr. Chen,

i've managed to connect CiteSpace to MySQL. My goal is to create a Keyword concept Tree, which i've already managed (as shown in the image attached).

Is there a way to "merge" Keywords within the concept tree?

For example, I'd like to merge "corporate social responsibility" and "csr". Since i'm already using a citespace.alias to merge the keywords in cluster- and timeline-visualizations, it'd be perfect being able to do so in the concept tree as well.

Furthermore, I'd like to mention that i've no previous experience with MySQL. Thus, i'm not quite sure on how to solve this issue using MySQL - even though I think creating a new table within the MySQL similar to the .alias-file is possible?

Thanks again for your support.

Best regards,
Tobias

[Chaomei Chen]

Looks good. You can merge them within CiteSpace as follows:
Data>Import/Export>MySQL: Edit: Edit A Record
CiteSpace will show you a template query:
Update keywords set keyword='xxxx' where keyword='yyyy' and project='your_project';
Then press the button 'Execute Query'
This will change keyword 'yyyy' to 'xxxx'.