Join

[Santhoshmdm]

Hi,

I have two tables with identical fields and want to join the fields to the first table, so that each record will have each record from the 2nd table. Created primary key field by using the script, RecNo() as Key. Both the tables loaded successfully and not sure why  showing script error as Key not found. Can somebody help me with the below error please. Thanks

 Product:

SKU,

[Standard Unit],

RecNo() as Key

from ........;

Hierarchy:

RecNo as Key,

ProdID,

ProductName

From ........;

Join Code 

Left Join (Product)

Load

Key,

Product ID,

Product Name

Resident Hierarchy;

[AshutoshBhumkar]

Hello

Try below code.

 Product:

SKU,

[Standard Unit],

RecNo() as Key

from ........;

Hierarchy:

RecNo as Key,

ProdID,

ProductName

From ........;

NoConcatenate

//Join Code 

NewTable:

Left Join (Product)

Load

Key,

Product ID,

Product Name

Resident Hierarchy;

Drop Table Hierarchy;

[Vegar]

You are missing a LOAD statement for your Hierarchy table. Try adding a 'LOAD' like I've done below. 

Hierarchy:

LOAD

RecNo as Key,.......

[AshutoshBhumkar]

Oops. I missed that too 🙂

[Santhoshmdm]

Thank you very much for looking into this.

Unfortunately I am not able to get to the desired result, below is the error screenshot.

[AshutoshBhumkar · Accepted solution]

Hello

Maybe that's because of NoConcatenate and Join combination.

You can remove NoConcatenate, and use below script

Product:

Load

SKU,

[Standard Unit],

RecNo() as Key

from ........;

Left Join (Product)

Hierarchy:

Load RecNo as Key,

ProdID,

ProductName

From ........;

Thanks,

Ashutosh

[Santhoshmdm]

It worked!! Thank you so much AshutoshBhumkar for looking into this.