Help on below requirement?

[daisy1438]

Hi

I have two tables.

Table1:

Load clientID, amount,location

Table2:

Load  clientId, Hours

Table2 field clientIds  is 75 and totals 75 clientID s having hours.

table1  clientId field having 275 clientIDS.with out hours.

my requirement is two tables clientId field combine into one filed.so only 75 clientID same the both tables. this same 75 clienIDs showing the hours and reaming un matched clientId hours showing 15.7.

how do this.please help/ 

[Gysbert_Wassenaar]

Try this:

MapHours:
MAPPING LOAD
    clientID,
    Hours
FROM 
    Table2
    ;

Table1:
LOAD
    clientId,
    amount,
    location,
    ApplyMap('MapHours',ClientID, 15.7) as Hours
FROM
    Table1
    ;