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