Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

i want to trying to separate dates into three columns alteryx

meziane36u
7 - Meteor

Hello ! 

 

 

I  want to trying to separate dates into three columns alteryx, where does this formula (\d+).(\d+).(\d+) ?

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @meziane36u 

 

You can use Regex Tool and Parse to split to columns.

atcodedog05_0-1608043243071.png

Hope this helps 🙂

leon2020
7 - Meteor

Looks like you are using a REGEX formula or tool.  And I guess the three columns you want to separate a date into is the day, month and year.  I assume the date is already formatted and recognised as a date.

 

In that case, I would not use REGEX.  I would use the formula tool and use the following built-in functions:

 

DateTimeDay([FieldName])

DateTimeMonth([FieldName])

DateTimeYear([FieldName])

 

If the date you have is not yet formatted or recognised as a date, you can add a step to parse/format as a date first, then do the above.  I should note, you could use REGEX and that would work also - more than one solution here, matter of preference.

meziane36u
7 - Meteor

Thank you very much it works  😀

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @meziane36u 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels