Clear Table fields in memory

[Zohar_B]

I am loading an excel table from my local memory. The loader didn't like the field called DATE (probably because it is a reserved word) and changed it to "Date". So I renamed the column in the excel file to OpDate. When I am trying to load data it still looks for the "date" field and dosn't consider the change, so I have to clear the cache memory. How do I do that?

Thanks for any help

[MartW]

@Zohar_B , how did you load your data?

via the datamanager? or via the data load editor (scripting)

if you load this via datamanager please go to the dataload editor

within the dataload editor you should change you the script a bit.

your script looks probably something like this:

Table:
Load 
   DATE as Date,
   Field
From location.xlsx 

you want to change the capital DATE to  OpDate.

Table:
Load 
   OpDate
   Field
From location.xlsx

 also the field is just a placeholder. you can change this at anytime 🙂 

the error you got is that Qlik will start at the top a the loadscript. it opens the file and is looking for a column called DATE. there is non because you updated the Excel. therefore Qlik cannot find this and errors.

also a good thing to make sure you have done. if you have uploaded the file to Qlik (if you are working in Qlik Cloud, you should reupload the Excel file as well)