Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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...
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
Do remember field names are case sensitive in Qlik.
yes i know i have only one field in the second table and i know that i need to respect case sensitive
You need to provide the full script otherwise I can only guess.
Please post the entire script
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 ?
Problem resolved, i need in the where not exist add the original name of Field name :
Where not Exists(CHART,Field1);