issues on joining tables

[Chadlia]

Hi , 

I need to create calculated values from different tables. my source is an API 

I joined all the needed tables and I am receiving a result  but this result is not related correctly to the rest of the data . I can't filter it.

  What have I done wrong ? 

HISTORY1 :
LOAD

[__KEY_body] ,numero
resident body;
join load [__KEY_body] , [__KEY_sections]
resident sections ;
join load

[submittedDate],
[__KEY_sections]
resident statistics ;
join
load
[__KEY_history] , [__KEY_body] , [createdOn]
resident history ;

join
load [__KEY_history] ,[__KEY_summary]
resident summary ;

inner join
load [__KEY_summary],
[from],
[to]
resident status ;


FinalResult:

load

date(If([to]like 'granted' and [to] <> from ,createdOn)) as [grantedDate]

resident HISTORY1;

[Marcos_rv]

hat inner is filtering the records of the table, you could use left join, then the last table is not what you do.

I advise you that to the "join" statement, you add the name to the table to which you join,
for example :

HISTORY1:
LOAD
[__KEY_body], number
resident body;
join (HISTORY1)
load [__KEY_body], [__KEY_sections]
resident sections;

join (HISTORY1)
load
[submittedDate],
[__KEY_sections]
resident statistics;

join (HISTORY1)
load
[__KEY_history], [__KEY_body], [createdOn]
resident history;

join (HISTORY1)
load [__KEY_history], [__ KEY_summary]
resident summary;

inner join (HISTORY1)
load [__KEY_summary],
[desde],
[to]
resident status;