community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Asteroid

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? 

 

2017-11-28_9-04-59.png

Alteryx Certified Partner

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

image.png

Asteroid

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

 

1.png

 

2.png

 

 

 

 

 

 

 

Alteryx Certified Partner

@kheuer,

 

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

image.png 

 

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

Asteroid

Brilliant! This worked perfectly. Many thanks!

Labels