• State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 191 subscribers
  • Views 1553 views
  • Users 0 members are here
Options
Related

Merging misaligned termbases

Marta Kiezik

Hello,

I am a newbie to SDL software, so I will be grateful if someone could share their expertise with me and help me out.

I've got a bilingual Excel table that I want to convert into a termbase. However, the entries are horizontally misaligned, meaning some of them get pushed down because synonyms are listed in separate fields. The only thing that connects the entries are the corresponding concept ID numbers (meaning 3 synonyms will all be listed under a certain number, as seen in the picture below).

I tried to intuitively align the terms and merge the synonyms by trying out various options. Some solutions seemed to have worked at least partially, but overall the entries were still largely misaligned. 

Screenshot of an Excel table with bilingual terms misaligned. Column headers are 'Polish', 'conceptid 1', 'English', and 'conceptid 2'. Rows show mismatched concept IDs and terms.

Generated Image Alt-Text
[edited by: RWS Community AI at 6:45 PM (GMT 0) on 14 Nov 2024]
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply
  • 0 in reply to Lydia Simplicio

    Hello ,

    I've used SDL Converter to convert the Excel file. At this stage I tried to do it with just one common concept ID, no concept ID and separate concept IDs (concept ID 1, concept ID 2 for each corresponding language).

    After creating the termbase, I tried both 'Default import definition' and 'Synchronise on Entry Number' on each variation. The 'no concept ID' + 'Synchronise on Entry Number' combination achieved merging, but not alignment by concept ID number. Other results were not optimal.

    I know the problem lies in the file itself rather than the software, but I was hoping to be able to find a solution within the programme to sort out the mismatched data using one common value (in this case, the concept ID).
Children