STOPPING DATA AFTER A SPECIFIC DATE IN DATA SET

@AlteryxLearner23 - is this what you are trying to accomplish? I think I understood the ask. I chose the first of the month when building out the date from the column header, but it can easily be altered to end of the month with one additional formula if that works better for you.

testworkflow.yxzp

All comments

DanielG

testworkflow.yxzp

AlteryxLearner23

@DanielG Thankyou!

However, I'm unable to open your attachment. Not sure if it's me or the file itself.

caltang

Click on Import, then Yes. It should work - it works on my end no issue. If you still have issues, let us know.

DanielG

@AlteryxLearner23 - try this. You will just need to repoint the input to your file. Also I am on version 2022.1. Maybe that is the issue??? Give this a try and let me know.

testworkflow.yxmd

AlteryxLearner23

@DanielG @caltang

I think you are right, I need to update my software.

When I go to update, it says I need my "License Key Verification", which has dashes in it.

Where can I find this?

caltang

If you could access it fine before this, and now you're seeing that, it means your Alteryx license has expired. Kindly speak with your Alteryx program manager or your vendor / Alteryx partner to get your license keys renewed.

If you are using a trial version, it means the period has elapsed.

If you're on a SparkED license, and if you're still a student, you can ask for another renewal I believe.

Depends on the scenarios above, your issue is related to licensing and not what @DanielG gave I'm afraid...

DanielG

@AlteryxLearner23 - sounds like @caltang is right, however there is one other thing to try first just in case it isnt a license issue is to open the workflow in any text editor (I used notepad usually) and change the version in there. Then just save it and try to open it from Alteryx.

As long as the workflow isnt using any new features that arent available in your version it will work fine. I dont think I used anything super new in there, so you should be all set if that is the actual issue. 😊

AlteryxLearner23

Thanks @DanielG

I restarted my system and was able to download the file.

It works perfectly.

DanielG

@AlteryxLearner23 - Happy to help!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703