I've grouped all of the "NAMES" into the 3 unique values, "From, Name and Website" and numbered each as 1,2,3. Then after joining these three values to the incoming 9 records from the original data (where I previously numbered each unique record) I have ValueID 1, RecordID 3,6,9 and Value ID 2, RecordID 2,5,8 and ValueID 3 and RecordID 1,4,7. What I need to do is renumber the RecordID to be the same value for each set (e.g. 3,6,9 becomes 1 and 2,5,8 becomes 2).
The multi-row formula is GROUPED by ValueID.
The formula that I am applying is:
The configuration for "Values that don't Exist" is set to 0.
For the first record in the group (ValueID), this becomes 0 + 1 = 1. This formula adds one (1) to the prior row value for RecordID. 1,2,3 is the result for each of the sets. Now we are ready for the Cross Tab function.
Above is the before and after view of data coming into the Multi-Row Formula tool.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
to my youTube channel.