table field appears empty when joining tables

[ioannaiogr]

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.

[MayilVahanan]

Hi,

Its might be, due to "ExamId" from Results.qvd doesn't match with Table.
Else, format might be different (either text and number) format.