Flattening out / Pivoting / Transforming results
Hi,
I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I did have a little read on the forum and found someone talking about a pivot function, but I couldn't see it myself.
Any help would be greatly appreciated.
Will
Answers
-
Does your example data show 3 customers?
Customer1 first four rows, Customer2 one row, Customer3 two rows
If so, you want to Harmonize the data: "Harmonization is the process of deduplication - taking multiple records that are deemed to be for the same underlying real-world subject and producing a single resulting record."
1 -
Hi Josh,
Yes, those would be the 3 different Customers I should have made that more clear.
Ah, Harmonize is exactly what I'm looking for, thank you!
1 -
Josh, just a follow up question if you don't mind.
The Harmonize step looks to create a "Golden Record" as such. I.e. If a Customer has two Salesforce ID's the Harmonize is currently picking the "best" one, and uses that on the final output. Is there anyway to use all, even if there are multiple?
0 -
You could process the data before the Harmonize step. One option is a Lookup step:
Select 'Lookup type' = 'All values' (or 'Sorted values') for your column where you want to keep all values, i.e. 'Email Address'
|Client Key | Email Addresses | |2 | test2@test2,example2@example,email@email |
0
