Questions about if and variables in scripts

[Anonymous]

Hi,

i want to run a script before the load script.

set vartest = "Hello";
set newTest = "";


if($(vartest) like 'Hello', 
  // Then
  $(newTest) = $(vartest) & ' World!', 
  // else
    $(newTest) = $(vartest) & ' how are you?'
);


tbl_name:
LOAD * Inline
[fieldname,
a
b
c
$(newTest) as newTest
];

The script editor shows error´s in the if statement. What´s wrong?

Regards,

sam

[sunny_talwar]

May be this:

set vartest = "Hello";

set newTest = "";

if $(vartest) = 'Hello' THEN

  $(newTest) = $(vartest) & ' World!',

ELSE

  $(newTest) = $(vartest) & ' how are you?'

END IF;

tbl_name:

LOAD fieldname,

           $(newTest) as NewTest;

LOAD * Inline

[fieldname,

a

b

c

];

[marcus_sommer]

I think it should be more look like this:

set vartest = Hello;

set newTest = "";

if '$(vartest)' = 'Hello' THEN

  let newTest = '$(vartest)' & ' World!',

ELSE

  let newTest = '$(vartest)' & ' how are you?'

END IF;

tbl_name:

LOAD fieldname,

          '$(newTest)' as NewTest;

LOAD * Inline

[fieldname,

a

b

c

];

- Marcus

[rahulpawarb]

Hello Walter,

Hope you are doing well!

Please modify your script as below:

set vartest = "Hello";  
LET newTest = if(vartest like "Hello", vartest & ' World!',  vartest & ' how are you?'); 


TRACE $(newTest);

Thank you!

Rahul