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.

Changing header

Tid14
8 - Asteroid

Hi, I am building a WF in which I have 3 headers namely

FY 2019

FY 2020

FY 2021

and I have to apply numeric formulas in these columns and then make it an app.

Here I want to use a logic where I can change these years Column to something static for applying the formula so when in next cycle the years will change to for eg:

FY 2020

FY 2021

FY 2022

we dont have to change anything in the WF and it picks from these headers only.

1 REPLY 1
messi007
15 - Aurora
15 - Aurora

@Tid14,

 

Do you're columns FY 2019, FY 2020, FY 2021 are always in the same position ?

Id yes you can read the file without header 

 

messi007_0-1631803159217.png

In the formula you will use F4, F5, F6 instead of FY 2018...

 

Hoe this helps,

Regards

Labels
Top Solution Authors