Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
trying to get subroutine called to use variable value.. the variables is set from a column using for. but getting errors.. any idea?
ListOfFiles:
Load * inline [
Files
ABC
ASD
AQW
AQSW
];
Sub ScanData
let vss = $(vSetofFile) ;
End Sub
Let vNumofFiles = noofrows('ListOfFiles');
For i= 1 to $(vNumofFiles)
Let vSetofFiles = fieldvalue('ListOfFiles',$(i));
Call ScanData
Next;
Try single quote around vSetOfFiles in subroutine as below -
ListOfFiles:
Load * inline [
Files
ABC
ASD
AQW
AQSW
];
Sub ScanData(vSetOfFiles)
let vss = '$(vSetOfFiles)';
End Sub
Let vNumOfFiles = NoOfRows('ListOfFiles');
For i = 1 to $(vNumOfFiles)
Let vSetOfFiles = FieldValue('Files',$(i));
Call ScanData(vSetOfFiles);
Next;