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