I have successfully created my incremental load script for my excel files. Next I have to create a series of dummies, etc that are based off of the data I currently have. My question is, what is this syntax, and will this cause errors in the rest of my code because the variable(s) I'm trying to create are not in the native excel/csv import:
My IF Statement is where I want to create a variable. I want to create 'Not_E-Oscar_Dum' based on the value of the variable Mode. Qlikview won't take my current syntax. What is wrong with it?!?!?!
Also, I'm going to have quite a few of these dummies created. When I create 'Not_E-Oscar_Dum' in the first LOAD statement I should just be able to then add 'Not_E-Oscar_Dum' to my 2nd load statement, correct?
//CET Data - Direct Disputes IFNOTISNULL(QVDCreateTime('$(vQVDPath)CETData.qvd')) THEN