Post Processing Transformation Plan in One Web

Hi ​@ritgupta thank you for posting! While I’m checking with the team, I wanted to share a post that might help in the meantime: 

Hello ​@ritgupta, ​@Ataccama Community Admin,

It has been a year, is there any answer to this?

Currently I'm using this:

Input, table A → Filter, expression = invalid_rules_explanation is not null (since we only want to show invalid records) → output.

However in my . csv I see for row1 multiple invalid_rules_explanations. This is not ideal for me nor the customer. We want to see row 1, person 1, invalid1, row2, person1, invalid 2.

How do we do this?

​@JTH    The best I have came up with on this:

1. Add the step “Transform Data”. Use a substr() on the invalid_rules_explanation to get just the part that matters.
2. Add the step “Condition” with the condition for one of your rules. (I think you may have to repeat this several times for multiple rules)
   • This should create a separate row for each reason failed. 
3. Union or join them back together (whichever makes sense for your .csv) then output.

I hope this helps. If you run into more issues post them. I am working through similar concepts but am trying to write to a SQL DB.