Change variable if files don't exist

johngouws — Mon, 29 Mar 2021 02:04:06 GMT

Good morning,
I am looking for a way to change a path variable. If the files do not exist in the RAW folder, load them from another folder.

It is important to use the number of files instead of EXISTS because some projects will have more files than others.

// This section counts the QVD's - In this case I get 3
Set vRoot = 'C:\RAW\Sense_QVDs';

Sub NoOfFiles(myPath, myNoOfFiles)
// Count the number of files, meeting creteria, in a path
Let tNoOfFiles = 0;
For Each File In Filelist ('$(myPath)')
// Count +1 for each file in the path
Let tNoOfFiles = tNoOfFiles + 1;
Next
Let $(myNoOfFiles) = tNoOfFiles; // Declare the variable and set the value
Set tNoOfFiles=; // Undeclare
End Sub

// Save the NoOfFiles in variable "vNoOfFiles"
Call NoOfFiles('$(vRoot)\Min_v0_*.qvd', 'vNoOfFiles')

// At this stage I have 3 QVD's

IF $(NoOfFiles) = 3 THEN

SET vRAW_QVDFolder = [C:\RAW\Sense_QVDs];
SET vWorking_QVDFolder = [C:\Projects\ProductionData];

ELSE

SET vRAW_QVDFolder = [C:\Projects\ProductionData];
SET vWorking_QVDFolder = [C:\RAW\Sense_QVDs];

ENDIF

.......

Thank you very much for you assistance.

topic Change variable if files don't exist in QlikView

Change variable if files don't exist