I have data exported from a server that I can create a Excel pivot showing the counts of various elements like dates, texts, etc. I am trying to create the workflow in Alteryx but it is counting cells that dont have a date, texts, etc. I created a filter to eliminate blanks, etc... and using data cleansing but nothing seems to work. I have the workflow attached and then I show on another tab of the file the comparison showing where Excel skips blanks but Alteryx keeps adding them as part of the count. I thought my filters would work but they cause the data counts to be wrong, any suggestions would be greatly appreciated.
Mike
Résolu ! Accéder à la solution.
@MikeFrancis1959 You can just use filter tools per columns. for example to remove any empty or null from 'MMO:All MM Received, you can use "IsNull([MMO:All MM PO's Placed]) and IsEmpty([MMO:All MM PO's Placed])" to remove those rows.
I think you're overcomplicating it. All you need is to change the Counts in the summarize tool to Count Non Null.
@MikeFrancis1959 I think what Christina suggested should work. Have you tried that?
Thank you both, I am still learning but with the help of this forum I am getting better!
Thanks,
Mike