If statement limitations in load script

alandilworth — Fri, 28 May 2021 21:17:10 GMT

Is it not possible to use if statements anywhere in the load script? It appears to me that it is only allowed inside table load statements.

For example, this is acceptable:

Table:
Load col1,
            col2,
            col3,
            IF(1+1=2,then,else) AS col4
Resident TempTable;

But this is not:

IF(1+1=2,then,else)

Table:
Load col1,
            col2,
            col3,
            col4
Resident TempTable;

I'm finding this to be a very big limitation. I'm hoping either I'm doing something incorrect or there is a workaround.

Thanks!

Re: If statement limitations in load script

jwjackso — Fri, 28 May 2021 21:33:07 GMT

I believe it is your syntax, If Syntax

IF 1+1= 2 Then

Something Here

Else

Something Here

EndIF

topic Re: If statement limitations in load script in App Development

If statement limitations in load script

Re: If statement limitations in load script