Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
I have a problem...
I have two tables :
first named tmp :
drop table tmp;
the second tmp_targa:
i would like to use Where not Exists between the two table like :
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 ->
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);