SFTP file reader for daily pulls

[Matt]

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.

[Dheeraj]

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.