Alteryx Filter Tool is Misclassifying Records

Question

Hey,

My filter tool is classifying something as true, when it should be false. I'm not sure why this is happening. I've attached my workflow below. The filter is pretty basic, I'm just checking to see whether the "payment date" came before the "death date".

Read_multiple_files.yxmc

Payment comparisonyxmd.yxmd

mock data.zip

AngelosPachis · Accepted Answer

Hi @davidogundipe ,

I think the issue arises from the fact that your "death date" column is a string data field but the "Payment date" is a date field.

If you convert the death date to a date field type, I reckon that will solve the issue you are facing with your filter tool. You can do that by stocking a DateTime parse tool just before the right input anchor. You can see that the results in the filter tool change

Hope that helps,

Angelos

DavidP · Accepted Answer

Hi @davidogundipe

Payment and Death Date are in different formats. Try this (see formula tool before join left input)