Full load and incremental load based on variable

[sridhar_sigired]

Hi,

I have a incremental code with variables.

IF $(vLoadType) = 0 THEN  // FULL DATA LOAD

///Code

ELSEIF $(vLoadType) = 1 THEN  // INCREAMENTAL LOAD

///Code

ENDIF;

So, whenever i want to do full load, i need to pass 0 for parameter value in QMC and incremental load need to change it to 1.

Instead of that i want to write a logic in QVW, where if particular full QVD is available in folder then, variable value should set as 1 for incremental load, otherwise it should go for full load.

Can any one help me to write a logic in generator, instead of manual parameter change at QMC?

Thanks for your help.

Regards,

Sridhar

[MK_QSL]

You can check whether file exists or not...

http://www.qlikviewaddict.com/2012/02/checking-file-exists.html

Command to check if a QVD file exists

[sridhar_sigired]

Hi,

Looks like QvdCreateTime() function is not there now, any alternated for this?

I have checked this function in help,  but not available.

[MK_QSL]

Are you sure QvdCreateTime() is not exists now?

[sridhar_sigired]

I am not expert, so can you please check below...

IF (isNull(qvdCreateTime('Fact_Table.qvd'))) THEN

//Full load script

ELSEIF (NOT isNull(qvdCreateTime('Fact_Table.qvd'))) THEN

//Incremental load script

ENDIF;

[MK_QSL]

IF (isNull(qvdCreateTime('Fact_Table.qvd'))) THEN

  //Full load script ... make sure that you are checking Fact_Table.qvd at right place... If possible try to give full path to check

// something like C:\QVDFolder\Fact_Table.qvd

ELSEIF

  //Incremental load script

ENDIF;

[sridhar_sigired]

Yes, i dont have QVD generator and QVD in same folder.

QVDData folder - Contains QVD's

QVDGenerator folder - Contains Generator.

So, u mean I need to write below?

IF (isNull(qvdCreateTime('..\QVDData\Fact_Table.qvd'))) THEN

  //Full load script ...

ELSEIF

  //Incremental load script

ENDIF;

[MK_QSL]

You need to write Relative or FullPath according to your need... Try both for checking...

[sridhar_sigired]

Thanks Manish for your time, it is working with Relative path.

[sridhar_sigired]

Looks like it is not possible for multiple QVDs at a time? right?