I am a new user to Alteryx designer. not able to fix below exception. Every day this column header name changes to present date( todays date) . want to Change Column header (2022-12-12) name is todays date to "Today Sales".
Please help me:)
Hi @Anjankumar2021
Input was:
Output as expected:
Designed the formula in such a way it will work dynamically for all the days you run in future,
IF Contains([_CurrentField_], datetimeformat(DateTimeToday(),"%d/%m/%Y")) THEN "Today Sales"ELSE [_CurrentField_] ENDIF
If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.
Many thanks
Shanker V
@Anjankumar2021 One way of doing this
You can use the Dynamic Rename to achieve your solution.
Please find the below solution for you.
IF Contains([_CurrentField_], datetimeformat(DateTimeToday(),"%d/%m/%Y")) THEN"Today Sales"ELSE [_CurrentField_]ENDIF
@binuacs -Thank you so much for your help and its working fine to me 😊
