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 the following workflow where I use a directory and filters to get the designated files I'd like to look at data. How can I then append all the data in these files into a single sheet?
You're looking to use the DYNAMIC INPUT tool. Here's a quick video of mine that illustrates alternative approaches (you might want to subscribe to me on youtube).
For the Input Data Source Template selection with dynamic input, how am I able to select the files from the directory tool I'm using?
Given that the schema for each file is the same, select the first 1 or 2 rows of data from one file and save that to a "Template.csv" file. Then use that template in the dynamic input tool.
Can you share the file? I am looking for the details of how to process the directory output and read the files in it.