Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Santhoshmdm
Contributor II
Contributor II

Join

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;

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner
Partner

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

View solution in original post

6 Replies
AshutoshBhumkar
Partner
Partner

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
MVP
MVP

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

Hierarchy:

LOAD

RecNo as Key,.......

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
AshutoshBhumkar
Partner
Partner

Oops. I missed that too 🙂

Santhoshmdm
Contributor II
Contributor II
Author

Thank you very much for looking into this.

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

Santhoshmdm_0-1635066247091.png

 

AshutoshBhumkar
Partner
Partner

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

View solution in original post

Santhoshmdm
Contributor II
Contributor II
Author

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