issues on joining tables

Chadlia — Fri, 21 Jun 2019 16:57:42 GMT

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;

Re: issues on joining tables

Marcos_rv — Fri, 21 Jun 2019 17:59:48 GMT

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;

topic issues on joining tables in App Development

issues on joining tables

Re: issues on joining tables