Text to columns doesn't work

[elfunambolo]

I want to split Value column in two column, one with Y-m-d and other with hour. I added the Text to column block and insert /s as delimiter but the second columns is not filled.

[atcodedog05]

Hi @elfunambolo 

Try delimiter as \s

[PhilipMannering]

The delimiter should be \s and you need to have the [DATE LOGGED] field set to string.

A better solution might be using a Formula Tool and using the formulae,

ToDate([DATE LOGGED])

To get the time, you can just use the Select Tool and set the data type to Time. 

[elfunambolo]

I already insert /s and I don't take Data logged as reference but Action Date columns

[atcodedog05]

Hi @elfunambolo 

As @PhilipMannering  mentioned the datatype should be string. Since it was date you were facing this issue.

I changed it to string in a select tool and its working fine now.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[elfunambolo]

I have some Date and Aging rows as NULL, why?

[atcodedog05]

Hi @elfunambolo 

The date format present is "%Y-%m-%d" not "%Y-%d-%m"

You need to change "%Y-%d-%m" to "%Y-%m-%d"

hence you need to change it.

[atcodedog05 · Accepted solution]

Hi @elfunambolo 

Ignore previous

I found the exact error.

I think you need to set the date format same as condition.

This might be copy-paste typo.

[atcodedog05]

Happy to help 🙂 @elfunambolo 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂