Joining Two QVD

[ksomosera10]

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!

[Anil_Babu_Samineni]

Remove Square Brackets and Try?

[ksomosera10]

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

[Anil_Babu_Samineni]

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;

[ksomosera10]

I still get the error.

Table not found error

Table 'MainTable' not found

LEFT JOIN (MainTable)

LOAD *

FROM ProjectTeam.qvd(qvd)

[Anil_Babu_Samineni]

Please share QVD's?

[ksomosera10]

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

[Anil_Babu_Samineni]

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

[prma7799]

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

[ksomosera10]

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