I have data that looks like this:
Name | Address | FormName
John | 123 Apple Drive | Form1 Form2 Form3
Dave| 133 Westchester Drive | Form1 Form2 Form3
How can I turn this into multiple rows based on that FormName column? So the result would be:
Name | Address | FormName
John | 123 Apple Drive | Form1
John | 123 Apple Drive | Form2
John | 123 Apple Drive | Form3
Dave| 133 Westchester Drive | Form1
Dave| 133 Westchester Drive | Form2
Dave| 133 Westchester Drive | Form3
So a row was created for each form for each person.
I tried using the tJavaFlex component but that seems too complicated for this simple task.
I found out that tNormalize does exactly this! I hooked up tNormalize to my tMap like this:
And in tNormalize component I specified what I wanted to separate on (spaces) and what column to normalize