Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Working with Dynamic column headers

Manjari
8 - Asteroid

Hi All, 

 

I have a set of files with dynamic column headers every month. Every month I need to run an Alteryx workflow that will provide the sum of sales. 

Here are the sample files attached. every month I need the workflow to provide sum of sales. 

 

Please write to me for any questions. 

 

Note: Each Month I have 10 to 9 files like the attached. 

2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @Manjari 

 

Save all of your monthly files in a directory, input directory, dynamic input files (with filename), group, summarize and rename fields.

Workflow package attached.  Extract to C:\temp to test.

If it works for you, like, share, accept as solution...

 

Capture.PNG

Qiu
21 - Polaris
21 - Polaris

@Manjari 
Feels like more a Analytic App.

😁

0513-Manjari_T.PNG

Labels
Top Solution Authors