Alteryx Designer Desktop Discussions

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

Working with Dynamic column headers

Manjari
Astéroïde

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 RÉPONSES 2

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

@Manjari 
Feels like more a Analytic App.

😁

0513-Manjari_T.PNG

Étiquettes