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?
Solved! Go to Solution.
Hey @ChrisMB!
Try adding a Text To Columns tool after your Cross Tab but selecting the Split to Rows option.
Hi @Kenda!
Thanks for this suggestion. However, the duplicate lines are in two columns in my example (see below, column Description and Result). If I use Text to Column on my Description column, the Results column still contains the concatenated results.
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!
Thanks, that works!