Syntax for 2 Inner Joins on 2 Group bys

tinkerz1 — Fri, 22 Jan 2016 14:55:35 GMT

SourceHi,

I am trying to use the same source table to find the maximum for 2 different groups and pull the distinct ID's for them
.

So the max ID of the order number and the Max Cust ID of the customer number.

So then I will have 1 table of both.

Where am I going wrong?

Source1:

LOAD

ID,

Cust-ID,

order_number,

cust_number

FROM $(File)

inner join (Source1)

LOAD

[ID],

MAX(order_number) as [ODnum]

resident (Source1)

group by

[ID];

inner join (Source1)

LOAD

[cust-ID],

MAX(cust_number) as [Cust_num]

resident (Source1)

group by

[cust-ID];

Re: Syntax for 2 Inner Joins on 2 Group bys

MK_QSL — Fri, 22 Jan 2016 15:00:23 GMT

Try Left Join instead of Inner Join

tinkerz1 — Fri, 22 Jan 2016 15:45:56 GMT

It was just a typo in my join field that threw the exception