Re: dynamically loading excel file - Qlik Community

diwaskarki · ‎2017-12-12

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 · ‎2017-12-12

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 · ‎2017-12-12

Other system functions just in case:

diwaskarki · ‎2017-12-13

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)