prompt for date -intreface tools

[Redzapplin]

Hi there,

I am looking to build a mechanism where in i get a prompt using an interface tools to input high and low date fields while running it form gallery. Input fields should be in a format like 001.2020 where 001 is the month and 2020 is the year. Can any one assist me on this?

[atcodedog05 · Accepted solution]

Hi @Redzapplin 

You can Interface Tools text input tool for this.

Workflow:

Here is a resource to help you out

https://community.alteryx.com/t5/Interactive-Lessons/Entering-Free-Form-Text/ta-p/243112

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 😀👍

[Redzapplin]

You are awesome!

[atcodedog05]

Happy to help 🙂 @Redzapplin 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Redzapplin]

Hi @atcodedog05 

Can you tell me the mechanism to put it in a single row? like without splitting it into high and low.

If I do a union it doesn't work.

[atcodedog05]

Hi @Redzapplin 

You can use a single filter like

[Low]="001.2020" or [High]="001.2020"

[Redzapplin]

tried it doesn't work - it just shows "low" as a prompt not "high"

[atcodedog05]

Hi @Redzapplin 

Here is a workflow for the task.

Workflow:

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 😀👍

[Redzapplin]

sorry for bothering and disappointing you again 😑

just found out the output in high shows as "012" where in I have input "006" as month

[atcodedog05]

Hi @Redzapplin 

No issues always happy to help

So basically the Low and High inputted in the Text box is not saved. "012" is the data which is there.

There is no data modification only data comparison. Condition either match Low or match High.

Even if one is matched then you will get in True.

Hope this helps 🙂