topic Is it possible to evaluate expressions in LOAD INLINE Expressions ? in QlikView

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

Mon, 16 Nov 2009 20:13:04 GMT

Hi,

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 ?

Best regard

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

shumailh — Mon, 16 Nov 2009 20:42:05 GMT

Hi Bertrand,

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)) ;


// then clean up...
drop table MinMaxDates ;

Regards,
Shumail Hussain

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

johnw — Tue, 17 Nov 2009 02:19:54 GMT

An inline table is just a data source like any other, so you can perform manipulations on it like any other:

LOAD
date(date#("Date",'YYYY/MM/DD'),'MM/DD/YY') as "Date"
,date("Date"+1) as "The Next Day"
,month("Date") as "Month"
,now() as "Now"
INLINE [
Date
2009/01/25
2009/07/18
];

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

rwunderlich — Tue, 17 Nov 2009 09:55:36 GMT

The way to load a function value without data, like to record the current time, is with AUTOGENERATE. For example:

LOAD now() as LoadTime AUTOGENERATE 1;

Is that what you need?

-Rob

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

shumailh — Tue, 17 Nov 2009 13:26:55 GMT

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 ;

Is it possible to evaluate expressions in LOAD INLINE Expressions ?

Tue, 17 Nov 2009 19:54:19 GMT

Thanks all for your answers,
I think I can deal with it now 🙂

Regards