How can i avoid write 100 raw data file name twice ?

paulyeo11 — Wed, 18 Mar 2020 01:54:53 GMT

Hi All

My below script work fine , i have 100 diff raw data file file.( in RED color ) i need to have 2 set. may i know how to have just one set ? So easy to maintence.

LET vComputerID = Upper(ComputerName());

SET vRAWPath = '\\SPOCK\D$\DATADUMP\QVRAW\';
SET vQVDPath = '\\SPOCK\D$\QLIKVIEW\QVDs\';

SET vFile200 = 'SO_PMC.CSV';

IF '$(vComputerID)' = 'DESKTOP-9837GT0' THEN

SET vRAWPath = 'C:\Users\Pauly\Dropbox\5 QV_Final\QV_RAW\'; //local folder
SET vINPUTPath = 'C:\Users\Pauly\Dropbox\5 QV_Final\QV_INPUT\'; //local folder

SET vFile200 = 'SO_PMC.CSV';
ENDIF

Paul

topic How can i avoid write 100 raw data file name twice ? in QlikView

How can i avoid write 100 raw data file name twice ?