Need to Create a New Column based on Data in Excel File

[kheuer]

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? 

[jrgo · Accepted solution]

@kheuer

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.

[kheuer]

@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?

[jrgo · Accepted solution]

@kheuer,

Yes. In the Input Tools configuration, there's an option to specify this.

 

Check this box and Alteryx will no longer use the first row for headers for your input file.

[kheuer]

Brilliant! This worked perfectly. Many thanks!