Help on below requirement?

daisy1438 — Sun, 02 Dec 2018 11:34:45 GMT

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/

Re: Help on below requirement?

Gysbert_Wassenaar — Sun, 02 Dec 2018 17:25:49 GMT

Try this:

MapHours:
MAPPING LOAD
    clientID,
    Hours
FROM 
    Table2
    ;

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

topic Help on below requirement? in App Development

Help on below requirement?

Re: Help on below requirement?