Is it possible to evaluate expressions in LOAD INLINE Expressions ?
I've several big table loads in one of my QlikView. And I would like to store the date of the end of each table loading. I thought the Load Inline command was the easiest way to do it, but I don't know how to evaluate date functions : for example the now() function is not evaluated. So I only have the string now() in my table (while I'm trying to get time :)).
Is someone know how to do this or have any workaround ?
I've done the same thing using following code on edit script code and put the start and end date in the variable.
MinMaxDates: load minstring(LoadDate_table1) as StartDate, maxstring(LoadDate_table1) as EndDate resident table1 //order by LoadDate_table1ASC ; // now get the values... let EndDate = peek('EndDate',0) ; let StartDate = peek('StartDate',0) ; let EndDay= day(peek('EndDate',0)) ; let StartDay= day(peek('StartDate',0)) ;
Sorry, I though you were looking for startdate and enddate of any field.
I also experience the same problem earlier and ended up with the below code.
for each File in filelist ('$(path)$(CurrentFileName)') LOAD * FROM [$(path)$(CurrentFileName)] (ansi, fix, no labels, header is line, record is 2 lines); load '$(File)' as FileName , FileTime( '$(File)' ) as FileTime , FileSize( '$(File)' ) as Size autogenerate(1) ; next File ;