topic Conditional ODBC selection in script in QlikView

Conditional ODBC selection in script

Anonymous — Fri, 27 Jan 2017 12:46:12 GMT

Hi guys,

I need to load my data from 2 different datasources by made of an external flag; I wrote an external TXT file where I stored a number which indicates the firm.

My external Ditta.txt file contains only:

SET Ditta=0;

SET Ditta=1;

In the script I used;

$(include=Ditta.txt);

So I have the value 0 for the first firm or the value 1 for the second one in the variable Ditta and then I need to use it to redirect the ODBC, but I'm not able to do it.

Can someone help me, please?

Thanks.

Re: Conditional ODBC selection in script

m_woolf — Fri, 27 Jan 2017 13:10:35 GMT

IF $(Ditta) = 0 THEN

Set vConnect = 'Your 0 connection string';

ELSE

Set vConnect = 'Your 1 connection string';

END

ODBC CONNECT TO $(vConnect);

Re: Conditional ODBC selection in script

jonathandienst — Fri, 27 Jan 2017 13:24:19 GMT

Rather than using the include file to set a flag, followed by logic in the model to interpret the flag, why not simplify things by putting the connection string in the include file instead (one per include file)?

Oh, and I would use must_include instead of include, so that a missing include file causes an error in the correct place, rather some obscure later error caused by the missing include file.

Re: Conditional ODBC selection in script

Kushal_Chawda — Fri, 27 Jan 2017 13:32:13 GMT

IF $(Ditta) = 0 THEN

Connection String for Ditta=0 // ODBC .....

ELSE

Connection String for Ditta=1 // ODBC .....

ENDIF

Edit : corrected syntax

Re: Conditional ODBC selection in script

Anonymous — Fri, 27 Jan 2017 13:54:05 GMT

Thank you for the reply; closing the instruction with END it returns a syntax error; I used ENDIF and it works properly 🙂

Re: Conditional ODBC selection in script

Anonymous — Fri, 27 Jan 2017 13:56:20 GMT

Thank you for the suggestion; I have to make a little modification to my scripts to apply everywhere!!

Re: Conditional ODBC selection in script

Kushal_Chawda — Fri, 27 Jan 2017 14:02:09 GMT

Yeah, that was syntax error. Btw, I have edited my response. Thanks for marking it as correct.