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.

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.