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 wrote a workflow that mass-loads 800 files with the same data schema into an access database. The flow works great, but I need to add one piece of data to my output. In all off my 800 xlsx input files, there is one value in cell C1 that I need to capture and add to the end of my one output tool. How do I best go about this?
Something like below is the approach I would take. However, not sure how this would fit in to your workflow specifically that's reading in 800 files. If it's not already set up as such, you'll need to convert it into a BATCH macro so that it can process each file independently.
@jrgo - this works really well, thank you! The only piece that complicates this is that Alteryx thinks that everything in line 1 is a header. Is there an option to tell Alteryx that this file does not have any headers?