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.
I have a bunch of sales files with different information in the filename... let's use store number as an example. I can parse the filename to get said store numbers, but I want to be able append the store number to the sales data. When I use a Dynamic Input after using a Directory tool, the filenames don't pass through. I then have no way of identifying which line of data came from which file, so I can't add store number to the individual lines of data.
Does anyone know if there's a way to pass the filename or other downstream information through a Dynamic Input tool?
There is an option when you set up the "template" for the dynamic input (and for a normal input for that matter) which says "Use Filename as Field". This option will put your filename onto your data amf you can then parse out your store nimber from there.