If you need to transfer data from CSV or Fixed Width files, it is likely that they are being created with a varying filename to identify the date and time of creation.
In the CSV and Fixed Width Datastores there is a function to store wildcards so that the filename used in the process is constant but each of the actual files can be processed.
Once a process is run on a file (determined by the LastModifiedDate) it cannot process again, preventing any data loads duplicated to your source.
Within the brackets the type of characteristics expected are specified, for example, [0–9] means you can see any numbers within that range, [A–Z] allows any alphabetical characters within that range.
Within the braces, the first number denotes the maximum amount of characters, the second number denotes the maximum number of characters expected.
Literal to start or end an expected string.
Create a Wildcard
- Create a CSV Datastore — it must be a source.
- Note that in the file path, the files can be seen using their complete filename convention.
3. In the datastore go to the last tab — Filename Wildcards.
4. Click + New Wildcard
5. Give your filename an alias — this is how the file will appear in the Datastore.
6. In the value field save an expression that allocates variables [0-9] for numbers and [A-Z] for letters. Any other characters are expressed as they appear. End the string with the file extension as it appears in windows explorer. Select Save.
7. Click Scan > select Save
Your datastore now appears with a constant filename.