Table Name inside IF Condition

[Saravanan_Desingh]

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.

[sunny_talwar]

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

[Saravanan_Desingh]

I am hard-coding it now.

SET vSource='XL';

But planning to get this value thru a Button click.

[maxgro]

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;

[maxgro · Accepted solution]

use an action for the button

[Saravanan_Desingh]

Thank you so much, maxgro. This works.

[Saravanan_Desingh]

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

[maxgro]

Input Box