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.

Remove columns of future periods

tiverson
8 - Asteroid

I have a "Working Days" text input for an entire year, however all of my other data is only YTD (currently through P5).

 

When I create my output file, it shows the future period columns because the "Working Days" line has amounts.

How can I easily remove the columns that have no data on the other lines?

 

Is there a better way to calculate working days for just the current YTD periods that may not need a text file?

Thanks

 

Current output

tiverson_0-1646862411603.png

Working day text input

tiverson_1-1646862461378.png

 

 

 

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@tiverson 
Maybe we can do something like this.

0310-tiverson.PNG

Labels
Top Solution Authors