Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
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;
You are missing a LOAD statement for your Hierarchy table. Try adding a 'LOAD' like I've done below.
Hierarchy:
LOAD
RecNo as Key,.......
Oops. I missed that too 🙂
Thank you very much for looking into this.
Unfortunately I am not able to get to the desired result, below is the error screenshot.
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
It worked!! Thank you so much AshutoshBhumkar for looking into this.