Hi all. 🙂
So this weird thing keeps happening to me.
I have this script:
Table:
Load
ID1 as ID,
date(floor(Date1),'DD/MM/YYYY') as Date_Exam
Exam1ID as Exam_ID
from [$(pathQVD)Exam1.qvd] (qvd);
concatenate
LOAD
ID2 as ID,
date(floor(Date2),'DD/MM/YYYY') as Date_Exam,
Exam2ID as Exam_ID
from [$(pathQVD)Exam2.qvd] (qvd);
concatenate
LOAD
ID3 as ID,
date(floor(Date3),'DD/MM/YYYY') as Date_Exam,
Exam3ID as Exam_ID
from [$(pathQVD)Exam3.qvd] (qvd);
Left join(Table)
LOAD
ExamID as Exam_ID
date(floor("Date_Results"),'DD/MM/YYYY') as Date_Results
from [$(pathQVD)Results.qvd] (qvd);
What happens is, when i do the left join on field Exam_ID, the Date_Results field appears empty (!) and I found out due to the master calendar for Date_Results where I got the field "a" not found error. Now that's a first for me, any idea why it happens?
If i just load the table without joining them through Exam_ID, that is I just keep ExamID with no alias (without "as Exam_ID"), the table loads just fine.
I'm literally clueless! 😳
Thank you in advance for your help.
