Glossary Converter - Adding multiple values for picklist fields when importing Excel spreadsheet - term duplicates

Question

Hi!

I would like to convert my Excel spreadsheet to a MultiTerm termbase. I have a set of pre-defined picklist values (e.g. subject (A, B, C) or status (A, B, C)) that should be automatically assigned during conversion inside my Excel spreadsheet (see screenshot below). Using the Glossary Converter, the terms get duplicated which is not desired.

For example:
I have a subject (or status) field with multiple picklist values that should be added to the term altogether. However, I get multiple identical term entries/duplicates.
Something that MultiTerm does not really allow either (see error below; bug?).

Is there a trick to get the desired result?

Excel spreadshirt before conversion:

After conversion using the Glossary Converter (entry level (subject); term level (status)) (3 terms, 2 duplicate terms):

Please help! Thanks!

Best regards,
Manuel

Generated Image Alt-Text
[edited by: Trados AI at 1:07 PM (GMT 0) on 5 Mar 2024]

Almudena Ballester · Answer

Hi Manuel, 
 You need to use picklist in Excel this way:

Same with Status: 
 
 And you will obtain this:

Hope it helps, 
 
 Almudena

Trados Studio > 3. MultiTerm

Glossary Converter - Adding multiple values for picklist fields when importing Excel spreadsheet - term duplicates