Data extraction issue

[MD2050]

Hello Everyone-

I need some assistance in understanding what i am doing wrong in the attached workflow?

Situation : i have a set of data which has employee hours by day , please see attached excel file for reference (for this illustration i just pulled yesterday's and today's data) . i am trying to schedule a job which will run every morning and will show a summary of hours worked from previous day .

I used a filter tool and in the expression box i did DateTimeAdd(DateTimeToday(),-1,"days") , for some reason this logic is not working in my case and i don't see yesterday's data at the "True" node.

Thank you very much.

[MSalvage]

@MD2050,

in this sample workflow it does not look like you are giving the filter a boolean condition. For a filter to work you need a condition that can be marked true or false.

Instead of the If statement you have written try:

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

Best,

MSalvage

[danrh · Accepted solution]

Try these two changes:

- Change your expression to DateTimeAdd(DateTimeToday(),-1,'days')=[Date]

- Just prior to your filter, add a Select tool and change your Date field to a DateTime type.  Right now it looks like your comparing a Date and a DateTime and the two don't always play nicely.

Hope it helps!

[MD2050]

Thank you very much danrh - 

It worked perfectly.

[MD2050]

Thank you MSalvage for the prompt response.

Just a curiosity , I am new to Alteryx and i am loving it . Is there documentation which explains the fundamentals of the tool ? 

[MSalvage]

Yeah there is a ton of documentation on all the tools. Just a few ways I would recommend. If you left click on a tool in the tool bar, it will give you a brief description and some tools have examples you can open.

Also, with any tool if you are clicked on it on the canvas, you can click the ? and it will link you to a full, much more in depth, description of the tool.

And of course there is the Alteryx academy where you can watch videos/take courses on specific tools/sets of tools.

It is a great tool and it has plenty of support behind it. Have fun!

Best,

MSalvage