alandilworth
Partner - Contributor III
2021-05-28
05:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If statement limitations in load script
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!
583 Views
1 Solution
Accepted Solutions
jwjackso
Specialist III
2021-05-28
05:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 Reply
jwjackso
Specialist III
2021-05-28
05:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content