I have data like this
ID phone1 phone2
a 123-4567 null
a 123-8910 null
And I don't necessarily want to dedupe that second ID and throw away the row because I want that second phone number in phone2, like
ID phone1 phone2
a 123-4567 123-8910
So I can write both phone numbers to a SQL DB tables with a PK on ID.
How do I do this in Data Flows?



