Creating one columns with all the Failing information

Wojciech Glowacki
Wojciech Glowacki Member
in General

Hello everyone,

I have a question. When we do the validation step we have the "show all rows result". Is there a way to create a new column where where it contains all the header names for which that row fails or in that column have somehow information on all the rules it is failing. Thank you very much in advance!

image.png

Answers

  • Josh Boxer
    Josh Boxer Administrator
    edited April 28

    Create an Issue list and feed into it all Failing rows

    https://docs.experianaperture.io/data-quality/aperture-data-studio/objects/issue-lists/

    Run the Workflow to populate the list. Issue lists contain a column Failed rules, which is a comma separated list of the failed rules for that ID

    image.png
  • Wojciech Glowacki
    Wojciech Glowacki Member

    Hi @Josh Boxer,

    thank you this is very helpful. I apologize but I cannot seem to find this "column Failed rules". When I open my issue list after running the workflow I see screenshot 1. If I go to "show steps results" of the Track issues step in the workflow I see screenshot 2. That list does not have any Failed Rules column. Thanks in advance for your help!

    Screenshot 1

    image.png

    Screenshot 2

    image.png
  • Josh Boxer
    Josh Boxer Administrator

    Good progress. If you use the Issue list you created as the Source of a Workflow then you can see the Column as in my screenshot.

  • Wojciech Glowacki
    Wojciech Glowacki Member
    edited April 29

    Hi @Josh Boxer ,

    thank you again for your answer. It works :)

Categories