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