Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to fill a column based on month of running?

Isha_Gupta
8 - Asteroid

Basically I have a process in which i perform vlookup between 2 files and fills values in a different column.

 

Columns are named Jan forecast values, Feb forecast value, Mar forecast values and so on... Until Dec forecast values.

 

When I am running report in January for January input files, I want the lookup values to be filled in the column header Jan forecast values, when done in February, with February input files the corresponding values must get populated in Feb forecast values etc...

3 REPLIES 3
Raj
16 - Nebula

so what you can do is add a dynamic filter tool and create a dynamic formula selecting the current month.

Raj
16 - Nebula

Contains([Name],tostring(DateTimeFormat((DateTimeToday()),"%b"))
something like this.

binuacs
21 - Polaris

@Isha_Gupta Dynamic select tool would be useful for your use case

image.png

Labels
Top Solution Authors