Import with translate incoming values to other

Dear Daniel,
I figured out how to set them and succeeded in what I wanted to do.
Thanks a lot.
vData is a great tool.

Hello Ken,
That's also the right away but You do not need to create another table, It can directly be referenced with Categories table with either alias or Title ( if duplicate titles do not exist ). Please share your back end & FTP login credentials via contact us form, We'll look into it.

Dear Support,

I imported category titles from another system, but not their ID, into my new system. So category IDs are different now.
Now I import related articles. I need to translate the old category ID into new ones so that articles fall into their correct category.
I am not sure if it is the suggested method but I tried the "ReferenceTo" option in my new system Import profile at the catid field.
I created a translation table which maps old_id to new_id.
Then I set at catid: ReferenceTo "#_translate" ON "new_id" Select Columns "old_id".
But I always get empty catid at all records.

Did I do wrong? Thank you.