field not found in statement where not exists

[zied_ahmed1]

Hello,

I have a problem...

I have two tables :

first named tmp :

tmp:

load *;

SELECT ,

  Field1

FROM table1

[Doc]:

LOAD

Field1

  resident tmp;

  drop table tmp;

the second tmp_targa:

tmp_targa:

LOAD chart

;

SELECT CHART

FROM Table2

i would like to use Where not Exists between the two table like :

final:

load*,

Where not Exists(CHART);

But I have a problem that the field chart is not found

what is the problem ?

[sunny_talwar]

What is the resident table here? Have you shared just the bits and pieces of the script? I would suggest sharing the complete script to help you better here...

[zied_ahmed1]

Yes this is a little of the script,

i removed other fields because we need to concentrate into Field1 and CHART because i need to display data of Field1 without the data similar in the second table for chart

[Anonymous]

Do remember field names are case sensitive in Qlik.

[zied_ahmed1]

yes i know i have only one field in the second table and i know that i need to respect case sensitive

[Anonymous]

You need to provide the full script otherwise I can only guess.

[vinieme12]

Please post the entire script

[zied_ahmed1]

the problem is here ->

final:

load*,

Where not Exists(CHART);

load* is for the first table so it's normal to tell me that the field CHART is not found,what can I do guys ?

[zied_ahmed1]

Problem resolved, i need in the where not exist add the original name of Field name :

Where not Exists(CHART,Field1);