Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have the following directory C:\Root\Parent Folder\SubFolders. The two SubFolders are as follows
CA and IR (subfolders). So I would to like to have a situation like this:
If vSubFolder = 'CA' then
Load file1,fil2,....
else
if vSubFolder = 'IR' then
Load file3,file4,...
Please assist
Thanks
I thought may be I should first declare a variable, but maybe let me not include the variable.
Why do you need "if" or "else" ?
you can normally do it as following:
Load
Field1, Field2
From [C:\Root\Parent Folder\CA\ Filename.qvd] ( note: you can use " %" or " *" e.g " *.xlsx" it will load all xlsx files)
Noconcatenate
Load
Field1, Field2
From [C:\Root\Parent Folder\IR\ Filename.qvd]
Thank you , it make sense