This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Ah. There's probably a million ways to do that, but I'd do it quick and easy and use a text to columns tool delimited by the underscore, with only three or four columns. On the field with the m## and d## just take the right 2.
How could the filename be extracted within a dataflow in order to insert into a filename field and / or part of the filename parsed as a new field value. I am using the Directory input tool in order to 'loop through' multiple files and process various data / schema within the workflow and want to input the filename as a field value and part of the filename as field for all records processed.
For each file you're looping through - are you reading in the data with a Dynamic Input tool? In the configuration for the Dynamic Input tool template, you can select to add the file name to the data, just like you can in a regular Input Data tool.
I'm using 'change the entire file path' as I'm inputting data from many files "This communication, including any attachments, may contain confidential and privileged information that is subject to the CNX Resources Corporation Business Information Protection Policy. The information is intended solely for the use of the intended recipient(s). If you are not an intended recipient, you are prohibited from any use, distribution, or copying of this communication. If you have received this communication in error, please immediately notify the sender and then delete this communication in its entirety from your system."