This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an input source(SQL server ) . Through this i get millions of records . And then , before getting into the flow (Filters and select) . I need to have the ability to select the date at the input . Is this possible in alteryx . Like using the date or dynamic input field at the input data source?
If you want add a date column in your record then just after input tool place a formula tool make a column named "Date" with date/datetime type and use function "DateTimeToday()". then you'll get current date in a separate column in your file.
Hi Vishwa , Thank you for your reply . The database already consists of a field that states the date and time . I just need to have the ability to use a parameter to select the date at the beginning of my workflow . ie at the input .
Thank you for your reply . The database already consists of a field that states the date and time . I just need to have the ability to use a parameter to select the date at the beginning of my workflow . ie at the input . Do you think it is possible using the following mentioned tools ?
Thank you daniel . I just checked that particular tool . It queries in the database . It doesnt give me an option to select date . I need to have an easy ability to select date or dates . Thats actually the requirement .
See if you want to use only date fields then you can use Dynamic select tool where you can specify the types to select only specified type fields. Can you explain little bit more with example what you actually want?
I have a red shift data base which contans millions of records . So here i am using an input tool and connecting it to the appropriate table.
Once i connect using input command . I am basically writing this into an output ( which is a tableau data extract) .
The requirement here is . In those input data . I have a date field . In YYYYMMDD .
So i want to know is there any way without using SQL query that i can use any of tool in alteryx ( Preferably linked into the input) that lets me choose the date i require and generates an output file ?
So,After 2 months of creating this workflow. I want to select a random date and write into the output when i click on run. So is it possible in alteryx?