dynamically loading excel file

[diwaskarki]

Hi , I have an excel file in a drive, which I am loading to create a qvd table.

When I push the code to my production environment, the hardcoded path for the excel file wont work.

So, I need to do something like this.

If(ComputerName() like 'WP*') then

       read from this location.

-          Else

   read from this location.

How can I do this? Thanks

[luismadriz]

If wildmatch(ComputerName(), 'WP*') =1 then

      Load / read from this location.

-          Else

     Load / read from this location

end if

I hope this helps,

Luis

[luismadriz]

Other system functions just in case:

http://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/SystemFunctions/syste...

[diwaskarki]

Luis,

you are correct. For people who are having a similar issue. You need to do what Luis Said. Here is my code:

If wildmatch( ComputerName(), 'WP*' ) , then

LET variablename =  \\wvsdppx1\......\...........;

ELSE

LET variablename = \\.......\\......;

ENDIF

Then on your load statement do FROM $(variableName)