1. Keep translation of all languages in Excel sheet.
2. Use Vlookup function to get translation of each token.
3. Create sql update statement.
4. Export translation of project using Translation wizard in a table.
5. Update the table using the sql statement.
6. Import translation using Translation wizard


=VLOOKUP(D19,rngTranslation,MATCH(B19,rngLanguage1,0)+2,0)
UPDATE RST_KPI_2016_03_14_12h24m SET [TRANSLATION] = ‘Trading Group’ WHERE REFTRANSLATION = ‘Prod Level 1’ and [LOCALEID]=9439241;

Leave a Reply

Your email address will not be published. Required fields are marked *