topic Simple LOAD question in QlikView

Simple LOAD question

alexis — Fri, 10 Aug 2012 11:02:22 GMT

Hi all,

In my applicartion I have a need to create a table (I call it "ReloadTimes") that contains some data from a QVD file as well as some "local" information (see below to see what I mean.

Try as I might I always end up with just the one row (the content of the QVD file). The "local" stuff does not get added - I am sure it is something simple but it's Friday afternoon and my brain s already in "weekend" mode.

Regards

Alexis

LET vThisAppReloadTime=Now();

ReloadTimes:

LOAD Source,

ReloadTime

FROM

[Welfare_ReLoadTime.qvd]

(qvd);

LOAD 'ApplicationReload' As Source,

'$(vThisAppReloadTime)' As ReloadTime;

// $(vThisAppReloadTime) As ReloadTime;

Re: Simple LOAD question

Fri, 10 Aug 2012 11:13:59 GMT

Hi,

there is missing resident on the end:

LOAD 'ApplicationReload' As Source,

'$(vThisAppReloadTime)' As ReloadTime resident ReloadTimes;

Re: Simple LOAD question

Fri, 10 Aug 2012 11:28:02 GMT

resident is missing, but should be as follows:

table2:

LOAD * INLINE [

F1, F2

,'$(vThisAppReloadTime)'

];

LOAD 'ApplicationReload' As Source,

'$(vThisAppReloadTime)' As ReloadTime resident table2;

This will add new row to the ReloadTimes table.

regards

Re: Simple LOAD question

daveamz — Fri, 10 Aug 2012 11:37:12 GMT

Hi,

Or you can use directly:

LET vThisAppReloadTime=Now();

ReloadTimes:

LOAD Source,

ReloadTime

FROM

[Welfare_ReLoadTime.qvd]

(qvd);

LOAD * INLINE [

Source, ReloadTime

ApplicationReload,'$(vThisAppReloadTime)'

];

Regards,

Re: Simple LOAD question

alexis — Fri, 10 Aug 2012 11:53:22 GMT

Very helpful - thanx!

Re: Simple LOAD question

alexis — Fri, 10 Aug 2012 11:53:46 GMT

Thank you for your swift response.

Alexis