I was trying to use api to call a project by passing a filename as an parameter but I stuck at configuring the excel component to take the parameter value and read the file from S3. Could someone please help me. Thanks
I am also trying to read an excel file from S3 using the excel query component. Any idea on how to use a variable for the filename ?
Hi @chiratla.cert and @jubith.kariyath,
It's often times easier to use a python script that leverages the read_excel or ExcelFile.parse methods in the Pandas module. It's substantially more flexible and the options are almost limitless on what you can do with it as it pertains to Excel files of various types. Unfortunately, the Matillion component is quite basic and really only works in those basic scenarios. Hopefully this helps in some way!