creating calculated fileds from 2 tables

[#1]

I have 2 tables in my load script that I want to create some calulated fields from. I have tried to create a resident load but it doesn't work

This is what I have at the moment

MLST:

LOAD AUFPL as operationno,
APLZL as counter,
AUFPL+APLZL as opno,
MLST_ZAEHL as milestoneno,
Right (MLST_ZAEHL,5) as milestone,
MLSTN as usage,
TEDAT as scheduleddate,
LST_ACTDT as actualdate,
if((TEDAT>today()),TEDAT) as FutureMilestones,
if(TEDAT>Today()and TEDAT <Today()+35,TEDAT)as '5WeekOverview',
if(TEDAT>=WeekStart(today(),0,-1)-7 and TEDAT<=WeekStart(today(),0,-1),TEDAT)as PrevWk,
if(TEDAT < Today() and LST_ACTDT = '',TEDAT) as CurrrentDelinquent



FROM

(qvd)

where MLSTN = 'N0003';

left join
LOAD ZZMLST_ZAEHL1 as milestoneno,
ZZMLST_TEDAT1 as Customerbaseline

FROM

(qvd);

Calctable:
left join MLST:
load
actualdate,
scheduleddate,
customerbaseline,
if(actualdate > customerbaseline and scheduleddate > customerbaseline and customerbaseline > '',scheduleddate) as completeddelinquent,
if(actualdate = '' and scheduleddate > customerbaseline, scheduleddate) as projectdelinquent
Resident MLST;

[swuehl]

Yes.

And consider that using joins may increase your number of table rows (duplication of lines), if there are 1:n relations. Maybe a mapping approach or just linking tables would be better.