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,

     ...