topic Re: Execute Command with variable in QlikView

Execute Command with variable

lawrance — Sun, 25 Jun 2017 00:40:11 GMT

Hi all,

I try to delete the CSV files in particular folder using Execute command but it is not deleting.

The following scenarios which I tried,

S1:

EXECUTE CMD.EXE /C del "$(v_Fldr_MTR_RDG_CSV)COMED_MTR_RDG_*.csv";

EXIT Script;

S2:

EXECUTE CMD.EXE /C del "$(v_Fldr_MTR_RDG_CSV)COMED_MTR_RDG_*.csv";

EXIT Script;

S3:

EXECUTE CMD.EXE /C del "..\..\..\Shared\Shared_Common_Files\Static_Data\COMED_MTR_RDG_*.csv";

EXIT Script;

Also I have enabled the below options

Note: The variable contains folder path location ..\..\..\Shared\Shared_Common_Files\Static_Data\

When I run the above script in QMC it is deleting.

Thanks,

Lawrance A

Re: Execute Command with variable

Kushal_Chawda — Sun, 25 Jun 2017 08:17:16 GMT

have you tried checking this option in Setting->User preference

Re: Execute Command with variable

RSvebeck — Sun, 25 Jun 2017 11:41:42 GMT

Same user running the qmc service as when you are running QV Desktop? If not, your user has perhaps not the correct file/folder access?

Re: Execute Command with variable

lawrance — Sun, 25 Jun 2017 16:49:40 GMT

Hi Chawda,

Yes, It is in enabled state but not working

Thanks,

Lawrance A

Re: Execute Command with variable

lawrance — Sun, 25 Jun 2017 16:54:02 GMT

Hi Svebeck,

Here I missed one thing.

If I give full path without storing variable and without using ..\..\..\Share\

For Example,

I got output when using below mentioned script but I need to do in variable

EXECUTE CMD.EXE /C del "E:\Source\Shared\Shared_Common_Files\Static_Data\COMED_MTR_RDG_*.csv";

EXIT Script;

Thanks,

Lawrance A

Re: Execute Command with variable

vishsaggi — Sun, 25 Jun 2017 17:00:05 GMT

Did you try this: I mean without Quotes while reading from variable. And is your E a shared drive or a local drive on the server. IF it is a shared drive you might have to use actual drive name like \\sharedfile\Source\......; some thing like this.

SET v_Fldr_MTR_RDG_CSV = 'E:\Source\Shared\Shared_Common_Files\Static_Data\';

EXECUTE CMD.EXE /C del $(v_Fldr_MTR_RDG_CSV)COMED_MTR_RDG_*.csv;

EXIT Script;

Re: Execute Command with variable

lawrance — Sun, 25 Jun 2017 17:13:45 GMT

Hi,

I have tried but in Variable overview not in Script.

Thanks,

Lawrance A

Re: Execute Command with variable

BalaBhaskar_Qlik — Sun, 25 Jun 2017 17:20:45 GMT

S1:

EXECUTE CMD.EXE /C del $(v_Fldr_MTR_RDG_CSV)"COMED_MTR_RDG_*.csv";

EXIT Script;

Re: Execute Command with variable

vishsaggi — Sun, 25 Jun 2017 17:28:59 GMT

Does not matter did you give a try ? Is it still not working?

Re: Execute Command with variable

lawrance — Sun, 25 Jun 2017 18:45:28 GMT

Hi Bhaskar,

Thanks for your response.

I got the output which which I'm expected.

I have tried below scenario and got output.

Script:

EXECUTE CMD.EXE /C del $(v_Fldr_MTR_RDG_CSV)"COMED_MTR_RDG_*.csv";

EXIT Script;

Also update the variable in variable overview.

v_Fldr_MTR_RDG_CSV = E:\Source\Shared\Shared_Common_Files\Static_Data\

Now, it is working fine.

Thanks for all your reply.

Thanks,

Lawrance A

Re: Execute Command with variable

vishsaggi — Sun, 25 Jun 2017 20:50:57 GMT

Did you try without the quotes, it worked for me without Quotes. Just checking.