Excel data from S3 to redshift

Matillion ETL
1

I get one excel file daily in my S3 location with the filename as current_date.xlsx

My requirement is to read the data from the excel file in S3 and update it to the redshift table.

 

How can I use a variable with the excel query component? Or should I use any other component? Any help is much appreciated.

 

 

2

Hai @jubith.kariyath​

You can use variables in excel query component itself. you can use variable for filename as well as folder .. If you want to load multiple file means use file iterator to do iterate files

cheers

3

I am still not able to figure out how to achieve this. The variable name is not accepted in excel query component. Any input ?