You can either JOIN the tables
or
MAP:
MAPPING
LOAD Id, country &'|'& region &'|'& age as value
FROM Table2;
LOAD Id,
Subfield( Applymap('MAP', Id), '|',1) as country,
Subfield( Applymap('MAP', Id), '|',2) as region,
Subfield( Applymap('MAP', Id), '|',3) as age,
...
