topic Re: dynamically loading excel file in QlikView

dynamically loading excel file

diwaskarki — Tue, 12 Dec 2017 21:41:03 GMT

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 — Tue, 12 Dec 2017 23:33:25 GMT

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 — Tue, 12 Dec 2017 23:34:56 GMT

Other system functions just in case:

diwaskarki — Wed, 13 Dec 2017 21:36:23 GMT

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)