In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Automate Export of Specific Columns to Excel & Save with File Name

Leanna12
7 - Meteor

 

Description of Process

    1. Export the output to excel for multiple routines
    2. For each output Action: Save as Todays Date & File Name on a share drive

Description of Input - IN ALTERYX

MM DD YY INITIALS V 2

Note Updates

NOTES

[07 MAR 23 LMW]

Decomm in Progress

[07 MAR 23 LMW] Decomm in Progress

[07 MAR 23 LMW]

Decomm in Progress

[07 MAR 23 LMW] Decomm in Progress

Description of Output (DESIRED OUTPUT IN EXCEL &

 

Leanna12_0-1678288953913.png

 

 

4 REPLIES 4
binu_acs
21 - Polaris

@Leanna12 Are you looking for the output in 3 excel files? 

Leanna12
7 - Meteor

@binu_acs Great Question! I am looking to output into one excel file for each work flow path. For this workflow, i just need one excel file. 

 

binu_acs
21 - Polaris

@Leanna12 One way of doing this

binuacs_0-1678291108448.png

 

Leanna12
7 - Meteor

Thanks for sending this over! It works but I need some more help with automating the file name. 

 

Heres what I posted as a new topic, sharing here too :-)

Excel Output File Name Configuration

Description of Process

 

    1. For each output Action: Save as Todays Date & File Name on a share drive
    2. I would like the file save to automatically reference a column in my data set with the file name and use that information to create the file.

Description of Input - IN ALTERYX

See Excel File Attached Called Input Sample

Description of Output (DESIRED OUTPUT IN EXCEL &

 

 

 I would like it to reference that data in the Column Called file name in the excel file attached.

 

 

Labels
Top Solution Authors