Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ksomosera10
Contributor II

Joining Two QVD

Hi Everyone,

I need your help. I can't continue working on Qlikview as I'm  receiving errors as I load the script.

Here's the error:

Table not found error

Table 'MainTable' not found

LEFT JOIN ([MainTable])

LOAD *

FROM ProjectTeam.qvd(qvd)


For your reference I will give you my current script:

[MainTable]:

LOAD *

FROM Projects.qvd(qvd);

LEFT JOIN ([MainTable])

LOAD *

FROM ProjectTeam.qvd(qvd);

STORE [MainTable] INTO MainTable.qvd;


THANKS FOR HELPING!

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: Joining Two QVD

It is working ... PFA..

View solution in original post

13 Replies

Re: Joining Two QVD

Remove Square Brackets and Try?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ksomosera10
Contributor II

Re: Joining Two QVD

I've removed all Square Brackets but error still persists.

Re: Joining Two QVD

What you gave the script, Try this and let me know

MainTable:

LOAD * FROM Projects.qvd (qvd);

LEFT JOIN (MainTable)

LOAD * FROM ProjectTeam.qvd (qvd);

//STORE [MainTable] INTO MainTable.qvd;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ksomosera10
Contributor II

Re: Joining Two QVD

I still get the error.

Table not found error

Table 'MainTable' not found

LEFT JOIN (MainTable)

LOAD *

FROM ProjectTeam.qvd(qvd)

Re: Joining Two QVD

Please share QVD's?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ksomosera10
Contributor II

Re: Joining Two QVD

It's a bit large. I could give you my script generating each qvd's if you want

Re: Joining Two QVD

Try same way with inline table for 5 records from each qvd and check. Because, It loads easy manner when you used Left to the Table using Join

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Honored Contributor III

Re: Joining Two QVD

Please share your application with 15 line debug or share qvd for at least 20 records

ksomosera10
Contributor II

Re: Joining Two QVD

Can you tell me how I can send qvd's here?