Dynamic Date Formula in InputData

Hello,

I have a Dynamic Date Formula that works as a Filter, but can't get it to work on input data. I'm trying to limit the records that get pulled in from source data for performance.

Ideally, i'd like to just the records for the Max Date. using Filter Tool, I have been able to get the below to work. Can I use a Max date function in input, or could this formula be used in Input?

[AsOfDate1] = ToDate(DateTimeAdd(DateTimeToday(), -1, "days"))

Thanks

Input

Accepted answers

DG_Tampa

For those interested, I found a formula that worked.

[DATE\ = CURRENT_DATE -1

All comments

Chandler_Bing

Hello @DG_Tampa

If your datasource is a DB you can use the sql query to limit the number of records , you can write the query in the sql editor tab of the input tool.

If your datasource is csv/excel/yxdb then the files will be of small size which alteryx can easily read without any issues and you can limit the size after the input tool using a formula or filter tool.

You can enable profiling and see which tools are taking more time to process the records.

Thanks

DG_Tampa

Hello,

thanks for the feedback. I was in sql editor on the I input, which is linked to a database. The problem I have is, all the formulas i'm trying is giving me errors. I tried linking the database, with no filters or manipulation, then created a "Filter" using the dynamic formula. I then copied that dynamic formula into my input (sql editor), but continue to get errors. I'm not sure what is going wrong at this point. While this particular workflow would work with either method, i'd like to utilizes this function on much larger workflows i'll be building)..note - i'm about a week in with my Alteryx knowledge, but am proficient in sql, excel, access, etc...

I will also try the profiling to see where my hangups are.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703