parameter date at the input

[gvishal9]

Hi All , 

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? 

Could you please help me out with this scenario ? 

Thank you 

[danielbrun2]

Hi,

What i think you are looking for is to use In-database tools to generate the right query, and the get the result into Alteryx. Take a look here:

http://help.alteryx.com/9.5/In-DatabaseOverview.htm

Best,

Daniel

[vishwa_0308]

Hi Vishsal,

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.

Regards,

Vishwa

[gvishal9]

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 . 

[gvishal9]

Hi Bolide , 

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 ?

[danielbrun2]

Hi,

It sure is. The in-database tool help you generate the query to the database. You could for example specify a filter on date. Then it will only pull data for the specified date.

Best,

Daniel

[gvishal9]

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 . 

[vishwa_0308]

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? 

[gvishal9]

ok . Here is the full context .

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?

[danielbrun2 · Accepted solution]

Hi,

See this video: https://vimeo.com/174339524

I hope this helps

Best regards,

Daniel