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