Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
It is working ... PFA..
Remove Square Brackets and Try?
I've removed all Square Brackets but error still persists.
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;
I still get the error.
Table not found error
Table 'MainTable' not found
LEFT JOIN (MainTable)
LOAD *
FROM ProjectTeam.qvd(qvd)
Please share QVD's?
It's a bit large. I could give you my script generating each qvd's if you want
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
Please share your application with 15 line debug or share qvd for at least 20 records
Can you tell me how I can send qvd's here?