Alteryx Designer Desktop Discussions

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

RENAME THE FIELD BASED ON DATES

Ronal_bal
Asteroid

Hi,

 

I've many fields with dates as there header.

 

eg: attached screenshot.

Ronal_bal_0-1686665917661.png

 

I want create a formula in dynamic rename tool which will add the word 'actual' to the prefix of the dates which are less than today's date.

 

any help will be grate

2 ANTWORTEN 2
DataNath
17 - Castor
17 - Castor

Hey @Ronal_bal, this expression ought to do it:

 

DataNath_0-1686666359867.pngDataNath_1-1686666385540.png

 

IF [_CurrentField_] < DateTimeToday() THEN 'Actual_'+[_CurrentField_] ELSE [_CurrentField_] ENDIF
npariso
Feuerball

Hi @Ronal_bal here is the formula that will get you to your solution.

IF [_CurrentField_] < DateTimeNow()
THEN "Actual "+[_CurrentField_]
ELSE [_CurrentField_]
ENDIF

Beschriftungen
Top-Lösungs-Autoren