Alteryx Crashing

I builded a workflow for you.

Datetimeparse allow us to create a proper date format.

Date time format allows us to create any string format from date.

If you want to read more about this please refer to this link: https://help.alteryx.com/20212/designer/datetime-functions

The workflow should meet your requirements so I just gave you this information as a little bit more background.

Date format.yxmd

All comments

I had an issue like this when I used the dynamic rename tool. I deleted it and the workflow started to work correctly but what I needed to do is restart the pc first.

After opening a workflow I had a small window(like 1-2minutes) when I actually could work with this workflow.

My suggestion would be to delete the 2-3 most recent tools and save the workflow with a new name and check if this will work for you.

Hi @Emil_Kos

Thanks for this - I haven't used a dynamic rename tool I dont think anyway.

I have deleted the last tool I added in which was a DateTime one and saved it as a new file and the same message keeps appearing.

Hi @JagdeeshN & @Emil_Kos

Ive figured out the culprit - it is the DateTime tool, but I have opened up a new workflow and tried to add it in and its having the same issue there so its not just on that one anymore.

Any ideas how to get round this?

Thanks!

JagdeeshN

Hi @LoisGower ,

Have you tired to restart alteryx or your computer and try this again?

Best,

Jagdeesh

@JagdeeshN - I am just trying to do an Alteryx update and praying at works.... I had already rebooted both computer and Alteryx before writing on here

Thanks

What do you want to achieve with the date-time tool? I can write a formula for you so you could skip that tool from the workflow 😛

Please provide a sample of data and with the date-time format or date-time parse we will overcome this.

@Emil_Kos

😮 😮 😮 you can!?

so there are two;

DOB

Currently imported like 2021/08/11, I then used a DateTime tool so Alteryx recgonised it as a Date I think I did yyyy-mm-dd and then added another DateTime tool to change it to be read as Wed 28 2021

Then Trans Date again imported like 2021/07/22 and choose the yyyy-mm-dd and it comes out like 2021-07-22

I hope that makes sense.

Thank you so much for helping me out, it is greatly appreciated 😄

I builded a workflow for you.

Datetimeparse allow us to create a proper date format.

Date time format allows us to create any string format from date.

If you want to read more about this please refer to this link: https://help.alteryx.com/20212/designer/datetime-functions

The workflow should meet your requirements so I just gave you this information as a little bit more background.

Date format.yxmd

Hey @Emil_Kos

This is amazing thank you so much - just quick question, how would I get round the issue if I wanted to filter on date range as its a string it doesn't work? Or is this when I'd need to use the DateTime tool?

Many thanks,

Lois.