Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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