Left join resident tables

[#1]

Hi

I have this two tables

Temp1

Load distinct Names,Numbers

resident Oldtable

NoConcatenate

Sales:

Load

IDs,Products,Names

Resident OldTable

How do i Left join my Temp1 table to Sales when i have a NoConcatenate? Where should my left join be?

[#2]

not working

[SunilChauhan]

use left join only not noconcatenate

hope this helps

[its_anandrjs]

You can use Left Keep in place of the Left Join

Left keep (TempActiveUsersCookies)

[#5]

When i only use left join it says it can find column Number

[SunilChauhan]

it means some column Number has some syntax error .may be you can use like [Column Number]

check for that field

hope this helps

[#7]

like:

TempActiveUsersCookies:

Load Distinct

CookieIDINT as TempActiveUsersCookie,Count(DISTINCT SessionIDINT) as NumberOfBuys

Resident Hej

Where  upper(EventType) = 'BUY' and not isnull(CookieIDINT)

Group by CookieIDINT;

Left Keep (TempActiveUsersCookies)

NoConcatenate

Sales:

Load

CookieIDINT, NumberOfBuys

or?

[SunilChauhan]

it means some column Number has some syntax error .may be you can use like [Column Number]

check for that field

hope this helps

[its_anandrjs]

Try with

Left keep (TempActiveUsersCookies)

and not Noconcatenate

[#10]

If i do like that with no Noconcatenate it says filed not found (NumberOfBuys)

[its_anandrjs]

Check your code may be i believe you load any table twice or in the table when you Left Keep the table check the keys and make a composite keys to join them into previous table.

Hope this helps