Execute Command with variable

[lawrance]

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

[Kushal_Chawda]

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

[RSvebeck]

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?

[lawrance]

Hi Chawda,

Yes, It is in enabled state but not working

Thanks,

Lawrance A

[lawrance]

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

[vishsaggi]

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;

[lawrance]

Hi,

I have tried but in Variable overview not in Script.

Thanks,

Lawrance A

[BalaBhaskar_Qlik · Accepted solution]

S1:

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

EXIT Script;

[vishsaggi]

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

[lawrance]

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