Regarding a SUB and IF Statement

Mon, 01 Dec 2014 21:39:47 GMT

Hi All

I am having an issue writing a SUB Code that can be used to switch the table load code based on the type of file/table

such as '.qvd' or '.txt' being pulled.

1. vFILE is the variable name for the file being pulled, Its a text field

2. vFILETYPE is the extension name such as 'qvd' , 'txt' , 'xls' etc

and accordingly the load statement below needs to be switched based on the file extension suppplied in the function

SUB LOAD_CLAIMS(vFILE, vFILETYPE)
//===============================================================================
//===============================================================================
IF $(vFILETYPE) = 'txt'

THEN

$(vFILE):
LOAD *
FROM
[$(vPullPath)$(vFILE).txt]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
//===============================================================================
STORE $(vFILE) INTO $(vStorePath)$(vFILE).QVD;
DROP TABLE $(vFILE);
//===============================================================================

ELSE

IF $(vFILETYPE) = 'qvd'

THEN

$(vFILE):
LOAD *
FROM
[$(vPullPath)$(vFILE).qvd]
(qvd);
//===============================================================================
STORE $(vFILE) INTO $(vStorePath)$(vFILE).QVD;
DROP TABLE $(vFILE);
//===============================================================================

ENDIF

//===============================================================================

END SUB

topic Regarding a SUB and IF Statement in QlikView

Regarding a SUB and IF Statement