In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Listing the Volume that Changes Everyday

KamenRider
11 - Bolide

HI Guys,

 

I am working for a workflow that changes everyday since the number of accounts received is not constant. I would like to have this output as shown below

 

KamenRider_0-1645443725996.png

 

My problem is that the workflow get an error when I inserted the new excel file or data. Please help me how can the workflow accept the changes everday using the output I have. For file 021822, results should look like this:

 

KamenRider_1-1645444269892.png

 

Please see attached excel files and workflow for your reference.

 

Thanks and hoping to hear from anyone.

 

Kamen

 

11 REPLIES 11
KamenRider
11 - Bolide

Hi @atcodedog05  @binu_acs  and everyone

 

I added a sort tool between cross tab and transpose tab which automatically sort the header numbers even they are new figures.

 

KamenRider_0-1645546007600.png

Results

 

KamenRider_1-1645546041901.png

However, the final results is still unsolved. I hope someone would help to below results considering the color coding and chronological orders like as below.

 

KamenRider_2-1645546216009.png

 

Thanks and looking forward for anyone's ideas.

 

Kamen

 

KamenRider
11 - Bolide

Any help or assistance please.

 

Thanks,

Kamen

 

Labels
Top Solution Authors