Row Count - Threshold

Question

Hi,

I am inputting 10 excel files into Alteryx. I need to check each files row count and make sure the row count doesn't go above or below the threshold of (example: 25%).If it does go outside the threshold, then we should be able to catch it and label it as "Fail".

Is there a solution to this?

This is the first month of this process, but after a few months we will have a good average of what number to base the threshold off of.

Thanks in advance! Let me know if a deeper explanation is needed.

dpatel53 · Answer

The 25% can be interchangeable, so it can be 10 percent if we decide to use that.

I have the row count of the file and then another source coming in and telling me what to base the row count out of.

The are on a table side by side.

OTrieger · Answer

@dpatel53 
It is very simple to do the row count you can do it in several different ways, but how do you know if the count is 25%!!!
25% of what?

You need to define what is the quota so you can checked it against.

The minute that you get the row count you need to compare it to something, what is that thing that you will compare it to?

dpatel53 · Answer

Do you have an example of a logic?

I went ahead and brought over the data that the row count should compare too in the same table.