topic Re: Table Name inside IF Condition in QlikView

Table Name inside IF Condition

Saravanan_Desingh — Fri, 04 Dec 2015 17:07:47 GMT

Hi, I am trying to code something like this,

IF $(vSource)='XL' THEN

RawDate:

LOAD

FROM ...xls

ELSE IF $(vSource)='DB' THEN

RawData:

ODBC CONNECT TO SandBox;

SQL SELECT ..

END IF

Based on a condition, I am trying load data either from XLS or DB. But this is not working. Even I tried giving the Table Name (RawData) Above the IF Loop. No luck either.

Do you have any suggestion for me? In either case, I need the Table Name to be RawData.

Re: Table Name inside IF Condition

sunny_talwar — Fri, 04 Dec 2015 17:27:10 GMT

Where does the script determine if vSource is XL or DB?

Re: Table Name inside IF Condition

Saravanan_Desingh — Fri, 04 Dec 2015 17:29:25 GMT

I am hard-coding it now.

SET vSource='XL';

But planning to get this value thru a Button click.

Re: Table Name inside IF Condition

maxgro — Fri, 04 Dec 2015 17:37:38 GMT

this works, you have to adapt to your requirement the let vSource......

let vSource= pick(ceil(rand()*2), 'XL', 'DB');

// or let vSource = 'DB' ......;

IF ('$(vSource)'='XL') THEN

//RawDate:

//LOAD

//..

//FROM ...xls

TRACE 'XLS';

ELSEIF ('$(vSource)'='DB') THEN

// RawData:

// ODBC CONNECT TO SandBox;

// SQL SELECT ..

TRACE 'DB';

END IF;

Re: Table Name inside IF Condition

maxgro — Fri, 04 Dec 2015 17:42:37 GMT

use an action for the button

Re: Table Name inside IF Condition

Saravanan_Desingh — Fri, 04 Dec 2015 18:50:44 GMT

Thank you so much, maxgro. This works.

Re: Table Name inside IF Condition

Saravanan_Desingh — Fri, 04 Dec 2015 18:54:29 GMT

One more thing. What object you have used to get 'vSource=DB'?

Re: Table Name inside IF Condition

maxgro — Fri, 04 Dec 2015 19:20:37 GMT

Input Box