topic Re: Store into Different Library Based on Computer Name in App Development

Store into Different Library Based on Computer Name

carlcimino — Sat, 16 Nov 2024 02:53:13 GMT

Hello, I have an application that as I move up through our environments the store to drops to different folders.

For example if I am in the dev environment (Call it computer A) I want the file to drop to:

\\bifileshare\ApplicationOwnerFiles\Global_Finance\Concur_Extracts_QVD_Creator\Concur_Extracts_QVD_Creator_QVD\

If I promote it to our prod environment (call it Computer B) I want the file to drop to:

\\bifileshare\Concur_Qlik_Extracts\QVD\

To accomplish this I set up a few variables but I can't get the syntax correct in the if statement.

Let v_qsenvironment = ComputerName();

let v_devqvdlib = '\\bifileshare\ApplicationOwnerFiles\Global_Finance\Concur_Extracts_QVD_Creator\Concur_Extracts_QVD_Creator_QVD\';

let v_prodqvdlib = '\\bifileshare\Concur_Qlik_Extracts\QVD\';

if v_qsenvironment ='Computer A' then

store extract_CES_SAE_v3_2020 into '($v_devqvdlib)'/extract_CES_SAE_v3_2020.qvd' (qvd);

if v_qsenvironment='Computer B' then

store extract_CES_SAE_v3_2020 into '($v_prodqvdlib )'/extract_CES_SAE_v3_2020.qvd' (qvd);

endif;

Any help would be appreciated.

Re: Store into Different Library Based on Computer Name

Mauritz_SA — Wed, 25 Mar 2020 14:30:30 GMT

Hi @carlcimino

Maybe try the following with the red removed and the green added:

Let v_qsenvironment = ComputerName();

let v_devqvdlib = '\\bifileshare\ApplicationOwnerFiles\Global_Finance\Concur_Extracts_QVD_Creator\Concur_Extracts_QVD_Creator_QVD\';

let v_prodqvdlib = '\\bifileshare\Concur_Qlik_Extracts\QVD\';

if v_qsenvironment ='Computer A' then

store extract_CES_SAE_v3_2020 into '($v_devqvdlib)'/extract_CES_SAE_v3_2020.qvd' (qvd);

elseif v_qsenvironment='Computer B' then

store extract_CES_SAE_v3_2020 into '($v_prodqvdlib )'/extract_CES_SAE_v3_2020.qvd' (qvd);

endif;

Hope this helps.

Regards,

Mauritz

Re: Store into Different Library Based on Computer Name

carlcimino — Wed, 25 Mar 2020 19:16:17 GMT

Hi @Mauritz_SA thanks for the suggestion! I know it has to be something with syntax. When I used what you got the error below when I tried your suggestion. Here's what I did to test it out.

Let v_qsenvironment = ComputerName();

let v_devqvdlib = '\\bifileshare\ApplicationOwnerFiles\Global_Finance\Concur_Extracts_QVD_Creator\Concur_Extracts_QVD_Creator_QVD\';

let v_uatqvdlib = '\\bifileshare\ApplicationServerFiles\02_uat\QS\shared_misqs-uat.chubb.com\SourceDocuments\Global_Finance\Concur_Extracts_QVD_Creator\QVD\';

let v_prdqvdlib = '\\bifileshare\Concur_Qlik_Extracts\QVD\';

extract_CES_SAE_v3_2020:

Load

makedate(2019,12,31) as "Batch Date"

AutoGenerate

(1);

if v_qsenvironment ='NAUSD-WAPP0512' then

store extract_CES_SAE_v3_2020 into '($v_devqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

elseif v_qsenvironment='NAUSP-WAPP0509' then

store extract_CES_SAE_v3_2020 into '($v_prodqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

endif;

drop table extract_CES_SAE_v3_2020

;

exit script;

Re: Store into Different Library Based on Computer Name

Mauritz_SA — Thu, 26 Mar 2020 06:45:27 GMT

Hi @carlcimino

Sorry, I didn't see that you dollar signs weren't outside the brackets🙈. The following:

store extract_CES_SAE_v3_2020 into '($v_devqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

elseif v_qsenvironment='NAUSP-WAPP0509' then

store extract_CES_SAE_v3_2020 into '($v_prodqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

Should be:

store extract_CES_SAE_v3_2020 into '$(v_devqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

elseif v_qsenvironment='NAUSP-WAPP0509' then

store extract_CES_SAE_v3_2020 into '$(v_prodqvdlib)extract_CES_SAE_v3_2020.qvd' (qvd);

Hope this fixes it.

Regards,

Mauritz