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
binuacs
20 - Arcturus

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

Leanna12
7 - Meteor

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

 

binuacs
20 - Arcturus

@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