Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Help with If Component Advanced Settings

I am trying to create a project that determines a files 'format,' (ie. the columns and their types) and, using an if component, loads the data into the correct preconfigured redshift tables.

I have my Project set up to automatically run any time a file is added to S3 storage using Amazon Lambda functions per https://redshiftsupport.matillion.com/customer/en/portal/articles/2243961-triggering-etl-from-an-s3-event-via-aws-lambda?b_id=8915#header1.
As a result, there is a variable 'file_to_load' that I am hoping to make use of in checking for some string like 'storedata' within.

Any help would be greatly appreciated

Cheers

1 Community Answers

Alex Pollatos —

PS. The Script I am trying to use is this:

if (${format_prefix} in ${file_to_load}),

The corresponding error message:

Exception during evaluation: <eval>:1:33 Expected an operand but found if
function eval() { return Boolean(if (testuse in john/testuse.txt),); } eval();
^ in <eval> at line number 1 at column number 33

Post Your Community Answer

To add an answer please login