What's the syntax for the Dataset "file pattern" text when loading from an SFTP dropzone?

Henry Simms
Henry Simms Administrator
edited October 16 in General

I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name.

To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the syntax that was supported.

image.png

Are wildcards or regex supported? And can I specify paths to sub-folders here too?

Tagged:

Best Answer

  • Dan Mason
    Dan Mason Experian Employee
    Answer ✓

    From my experience playing around with this, wildcards such as Asterisk and regex are not supported (but I may be wrong!)

    What you enter into 'Starts with file pattern' will literally do what it says on the tin:

    Entering 'CustomerABC' would mean that only files starting with CustomerABC would be loaded.

    Not sure about paths to sub-folders in the dataset settings, but this can be configured in the external system settings:

    image.png

Categories