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
21 - Polaris

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

 

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels