AnsweredAssumed Answered

Mulitple rows to one row mapping

Question asked by akemp894336 on Apr 11, 2016
Latest reply on Apr 19, 2016 by mike_c_frazier

The source is a flat file with fixed columns, destination i want is preferrably an xml.

the source data could have multiple rows with same email.

but the destination should have one row per email with multiple attributes on the row mapped to the multiple rows on the source.

 

Source data format

email, name, amount

test@test.com, Universal Container, 100K

test@test.com, Makey Solutions, 250k

email@email.com, Prudent Inc, 230k

 

Desired destination:

Option 1: (preferrable)

<prospects>

     <prospect identifier="test@test.com">

          <name1>Universal Container></name1>

          <amount1>100k</amount1>

          <name2>Makey Solutions></name2>

          <amount2>250k</amount2>

     </prospect>

<prospect identifier="email@emailcom">

          <name1>Prudent Inc></name1>

          <amount1>230k</amount1>

  </prospect>

</prospects>

 

Option 2: or if we could get as below that is workable too (i think)

 

<prospects>

     <prospect identifier="test@test.com">

          <name1>Universal Container></name1>

          <amount1>100k</amount1>

     </prospect>

<prospect identifier="test@test.com">        

          <name2>Makey Solutions></name2>

          <amount2>250k</amount2>

     </prospect>

<prospect identifier="email@emailcom">

          <name1>Prudent Inc></name1>

          <amount1>230k</amount1>

  </prospect>

</prospects>

 

Any pointers?

Appreciate your help.

 

Thanks

Outcomes