We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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