topic Re: Left join empty table results in Error: field not found in QlikView

Left join empty table results in Error: field not found

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody,

I'm rather new to Qlik so i'mreaching out to you maybe some of you can shed light on the following matter:

I've a Facts table and trying to join some comments to it, like the following, but as you see on the last line of output, the join fails. Is this normal behavior when left joining an empty table?

temp:

LOAD

test.template_uid AS %template_uid,

test.month AS month,

test.comment AS temp_comment

(FROM [..\..\Datastore\Extract\test.qvd]

(qvd)

3 fields found: %template_uid, month, temp_comment,

0 lines fetched

Outer Join(Facts)

LOAD

%template_uid,

month,

temp_comment AS comment

RESIDENT temp

Error: Field not found - <%template_uid>

Re: Left join empty table results in Error: field not found

oknotsen — Mon, 12 Jun 2017 09:20:27 GMT

Could it be that you have a "QUALIFY *" statement somewhere before this piece of script? That would explain it.

Re: Left join empty table results in Error: field not found

Anonymous — Mon, 12 Jun 2017 09:24:50 GMT

Nope, i don't, not in the script.

Can it be in the doc properties somewhere?

Re: Left join empty table results in Error: field not found

kamal_sanguri — Mon, 12 Jun 2017 10:14:12 GMT

You actually don't need a resident load to do this.. Try below code and see, if you still get the same message

Outer Join(Facts)

temp:

LOAD

test.template_uid AS %template_uid,

test.month AS month,

test.comment AS temp_comment

FROM [..\..\Datastore\Extract\test.qvd]

(qvd);

Re: Left join empty table results in Error: field not found

Anonymous — Mon, 12 Jun 2017 11:00:56 GMT

Wow, Thank you,

I don't understand the difference, but when I applied your technique, the join works!

Re: Left join empty table results in Error: field not found

Anonymous — Mon, 12 Jun 2017 11:01:10 GMT

Can you maybe also explain the difference?

Re: Left join empty table results in Error: field not found

kamal_sanguri — Mon, 12 Jun 2017 12:01:51 GMT

So, what are you doing is Loading a table renaming few fields and then doing a resident load again to join, however renaming of fields and joining can be done in one go.

see this:

TableA:

Load aKey as key,

F1,

From

xxxxxxxx

Outer Join

TableB:

Load bKey as key,

F1,

From

xxxxxxxx

we are renaming the fields to make them join. Hope this will clear your doubts.

Re: Left join empty table results in Error: field not found

Anonymous — Mon, 12 Jun 2017 12:14:56 GMT

kamal_sanguri‌, i understand that, but why when doing the resident load, the join says: 'field not found',

and when doing the join directly from the source file, the join works? what is the difference?