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

Question

Description of Process

* Export the output to excel for multiple routines
* 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 &

23-03-10 Sample Macro File.xlsx

Sample Workflow.yxmd

Leanna12 · Answer

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

* For each output Action: Save as Todays Date & File Name on a share drive
* 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.

Sample Workflow.yxmd

Input Sample File.xlsx

binu_acs · Answer

@Leanna12 One way of doing this

Sample Workflow (5).yxmd

Sample Workflow (5).yxzp

Leanna12 · Answer

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