community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

Header Formatting Date

Atom

Hi everyone,

 

this might be a quick one for you, i am stuck though.

 

Id like to format the header row into proper Date format (e.g. Jan 15, oder Feb 16) after column 12. See pic attached

 

I understand that with "Select" I would format the whole column right?

 

Thank you!

Lalteryx.jpg

 

Alteryx
Alteryx

Hi @lz4000

 

You could use the Multi-Field Formula tool to update all your date fields at once. 

 

You can use this following expression: DateTimeFormat([_CurrentField_],"%b %d")

 

Best,

 

Jordan Barker
Solutions Consultant

Atom

Hi Jordan,

 

thanks. 

Does this let me format the header row only?

I tried your solution but it modifies the whole column

 

Thanks for you support

L

Alteryx
Alteryx

 

 

 Hello,

 

If you use the filter tool to only show the first record you can Union the data back together.  Hope this helps.

123.png

Alteryx
Alteryx

Hi @lz4000

 

You can also just filter the 1st row and apply the multi-row tool and then union the results back.

 

Best,

 

Jordan

Aurora
Aurora

Hi @lz4000

 

Another way to do this is:

- Add in a record ID tool - this will add a unique row ID to each row, starting with 1

- Then add a multi-field formula as @JordanB mentioned but with an if statement   

      if [RecordID]==1

      Then

                DateTimeFormat([_CurrentField_],"%b %d")

      else 

                [_CurrentField_]

      endif

 

this will fix the dates on the header row.

 

NOTE: if you want to use the header row (row 1), to rename the columns - this can be done with a dynamic rename - happy to mock this up if you need, just send over some sample data from your workflows (the data you have in the question above).

 

Cheers

Sean

 

Labels