Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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