Discussion board where members can get started with Qlik Sense.
I am looking to do insert and update within ticket # data.
So my data is a weekly csv that gets automatically sent to a directory.
The unique key is ticket # the other fields that change are closed date and comment section.
So i want the data load to update these fields if necessary when there is a new file dropped each week.
instead of creating a duplicate when these fields have data.
Is this possible when using CSV?
(I know i can just archive or delete old CSVs, but I would like this to work without having to do that)
Go to Solution.
This article apply to Qlik Sense as well: https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
This makes sense, the only question i have is within the incremental load.
"Where modified_date > $(Last_Updated_Date);"
Is the $(Last_Updated_Date) suppose to be a qlik function? what exactly goes here?
$(Last_Updated_date) gives you a value of variable 'Last_Updated_date' (dolar sign evaluates it).
This variable has been set by LET =(...) statement.
Oh okay, got that.
Now when i do my where clause " WHERE Closed > $(vClose);"
I receive the error = "
The following error occurred:
Field '>' not found"
Can you show us whole part of the script?
//Load data from QVD
"Planned start date",
"Planned end date",
"Description of Change",
//Find Last Closed Date
load max(Closed) as MaxClose
//Store Last Close Date to a variable
Let vClose = peek('MaxClose',0,'Last_Close_Date');
//Delete ChangeTest Table
Drop Table ChangeTEST;
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE Closed > $(vClose);