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