In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to export data into Excel template to a specific field in Excel.

Blewis21
8 - Asteroid

I get how to export into excel, but I need the values to go to a specific value

 

I can get the export to go to column 1 or column 2, but I specifically need that value to go to field B2, B3, and B4. 

 

What's the best way to accomplish this?

Side note: don't worry about multiple rows, there will always just be 1 row per execution. 

options.PNGtable.PNG

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

You can specify B2:B4 in the output configurations. The below should work for you, you may need to transpose your data and use a select tool to get rid of the 'name' field so the values appear as 3 rows first. 

 

Luke_C_0-1615921728261.png

 

Labels
Top Solution Authors