Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Use Text Tool to Describe Data Output

do55
6 - Meteoroid

I have built a workflow that combines several datasources and performs several "tests". Each test is recorded as its own column, {Test A: "Pass"/"Fail"} {Test B: "Pass"/"Fail) .....

 

 

Is there a clever way of analysing the outcome of these tests? I would like to finish the workflow with an email that says in the body:



XXXX records inspected with the following tests performed:

Test A: XXX records passed, XXX failed. (X%)
Test B: XXX records passed, XXX failed. (X%)

Test C: XXX records passed, XXX failed. (X%)

See attachment for detail of exceptions. 

 

 

The only way I can see to make this work is to add a filter, count and join for each XXX above which seems needlessly messy. Is there an easier option? 

3 REPLIES 3
grossal
14 - Magnetar
14 - Magnetar

Hi @do55,

 

I think I got something for you:

 

grossal_0-1589482192598.png

The result looks like this:

grossal_1-1589482211859.png

 

I'll attach the workflow for you. Let me know what you think.

 

Best

Alex

zajaccount
9 - Comet

Hi,

 

I first used the multi field formula to convert all the "passes" and "fails" to numbers (1 for passed 0 for failed).

 

Then I used the summarize tool to count the sum of the results columns and the counts, and then a formula tool to calculate the percentages and failed tests.

 

After this, these fields can be used in a text report:

 

zajaccount_0-1589482423769.png

Please see the attached workflow and let me know if it works for you.

 

 

do55
6 - Meteoroid

Great solution thanks!
I was previously going down a Python route, nice to use the native features.

 

 

Labels