I have following requirement. I got stuck in one point. Can someone help me out for that?
1. All the csv in the folder starts with PRISM(EMPLOYEE_CMO_2012_09,EMPLOYEE_Markets_2013_02,EMPLOYEE_City_2013_09...).For your information all the file ends with YYYY_MM. 2. As discussed there is a change in the field name from 2013_08. So whatever the file which has been received from 2013_08 will have different new name. All the files which was removed before 2013_08 will have old field name. 3. So while loading data from the new file (> 2013_07) it should load with the new fields and while loading from the data from the file (<= 2013_07) it should load with the old field name only. ---------------------------- This is the code which I have written to scan the files from a folder. But got stuck while loading csv files based the condition.
For each vFile in FileList('C:\QlikView\Source\EMPLOYEE_*.csv') Files: // reading csv files with yearmonth in filename LOAD *, right(subfield(FileName, '.' ,1),7) as YearMonth LOAD '$(vFile)' as FilePath, subfield('$(vFile)','\',-1) as FileName autogenerate 1;
if(File name contains >= 2013_08 it should load with new fields) // What should be the condition here???
TableName: EmpName as CustName, EmpId as CustId, field1, field2 from C:\QlikView\Source\EMPLOYEE_*.csv //How should I pass the filename here???
else
CustName as CustName, CustId as CustId, field1, field2 from C:\QlikView\Source\EMPLOYEE_*.csv //How should I pass the filename here???
By the way any idea how can I load latest 2 weeks of data? (i,e Current week and Previous week). Actually I was looking for that also. Also make sure that when we are in the first week of the year it should load first the current year and last week of the previous year as well. Any idea on this? Please help...
