Looking for component suggestion

hapablap

• January 19, 2015 00:00

• Answered

Follow

Hi,

I'm fairly new to Clover and I'm looking for some help with choosing which component to do a certain transformation.
All of the data is coming from a single excel file (one input)
Sample data:

1|a|-|-		
1|-|b|-
1|-|-|c
2|d|-|-
2|-|-|e
2|-|f|-
3|-|-|g
3|h|-|-
3|-|i|-

I am looking to merge these rows based on their row id (assume first column is row id)
Desired output:

1|a|b|c
2|d|e|f
3|g|h|i

Any help is much appreciated.

Cheers

• 

  imriskal

  • January 20, 2015 09:16

  0

  Comment actions Permalink

  Hi,
  
  You can use component Denormalizer. I think it is the one you are looking for.
  
  By the way, why your output does not look like the following?
  

  1|a|b|c
  2|d|f|e
  3|h|i|g

  
  Do you prefer the order of input records over field position?
• 

  hapablap

  • January 20, 2015 20:43

  0

  Comment actions Permalink

  Sorry I listed them in the wrong order, you are correct.
  
  I'll look into denormalizer and respond if I have any questions.
  
  Thanks!

Please sign in to leave a comment.