Hi, all: Sample data and desired output is in the attached workflow. I have a dataset with two columns - one contains repeating three field names and the other their respective values (9 lines total, making up 3 actual records. Here is how they are laid out in the data:
Record Field Name Value
1 Account 1
2 Code 100
3 Name ABC
4 Account 2
5 Code 200
6 Name DEF
7 Account 3
8 Code 300
9 Name XYZ
I want to transform them so there are three records total with the three field names and their respective values along the horizontal, as shown below. The Crosstab tool does not seem to be working the way I thought to accomplish this. Any help is much appreciated!
Record Account Code Name
1 1 100 ABC
2 2 200 DEF
3 3 300 XYZ
Solved! Go to Solution.
Hi @PWaicus
Here's a solution:
- Use Multi-Row formula if your "FieldName" field follows an order like "Account, field, field, Account"...
IF [Field Name] = 'Account' THEN [Value]
ELSE [Row-1:RecordID] ENDIF
This way you create the RecordID
- Use Cross-Tab Tool grouping by RecordID field.
WF attached.
CHeers,
Ahhh - perfect. Thanks much, @Thableaus!