Cross tab tool with multiple instances of same line

ChrisMB

Hi all,

I'm struggling with the following problem.

Input data looks as follows:

Desired output should be:

I'm trying with a Cross Tab tool and that is working fine. But the problem is that the Value 'Description' can occur multiple times per inspection. I want them so show on a separate line, but the Cross Tab tool by default concatenates them:

Any way to make sure that the description shows as separate lines?

Question.yxzp

danrh

Hey @ChrisMB, give this a go:

In the Filter tool, include all fields that could have duplicates.  The RecordID is to help maintain sort order for the Multi-Row Formula tool (which re-assigns the RecordID based on duplicate description/result fields).  At this point, the Crosstab can group on both the Inspection_grouping and the new RecordID.  Join them back together to duplicate your records from the false stream of your Filter, and you should be good to go!

Hope it helps!

solution.yxmd