Forum Discussion

Sgarim4's avatar
Sgarim4
New Contributor II
7 years ago
Solved

Date Filter for loading Excel File

I am trying to filter an excel file from a folder based on date to load onto a database. I have successfully managed to get the filter snap to filter out all months other than current month with the ...
date
expression_language
Anil's avatar
Anil
New Contributor III
7 years ago
Copy Link

@Sgarim4

Can you provide the input and expected output ?

  • Sgarim4's avatar
    Sgarim4
    New Contributor II
    7 years ago
    Copy Link

    Hi Anil,

    The input is from a filter snap with the above mentioned filter expression. This returns 2 files, for example one with 07/02/2019 date and another with 07/23/2019. The expected result from this filter snap here should be the file with the time stamp 07/23/2019 as that is the file with latest timestamp.

    Essentially, i am reading a directory folder where excel data files are added every month, and i am wanting to build a pipeline to read the latest file and drop the data after some manipulations onto the database.

    Regards,
    Santosh