Forum Discussion

Matt's avatar
Matt
New Contributor
7 years ago

SFTP file reader for daily pulls

Hello All,

We are going to start receiving delta files to a data warehouse and this is the format that our vendor specified that they will be sent over.

Company_Data_Storage_TITLE_YYYYMMDD_HHMM_YYYYMMDD_HHMM.txt

My question, in the file reader how would I format it so that it’ll be able to pull every day without having any issues.

sftp

1 Reply

  • Dheeraj's avatar
    Dheeraj
    Employee
    7 years ago

    Hi Matt,
    You need to use Directory Browser snap to filter the file by a pattern, then can connect file reader to output of Directory Browser snap and you can access file name and file path as snap properties in the reader.