Looking for component suggestion

CloverDX Platform
1

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

2

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?

3

Sorry I listed them in the wrong order, you are correct.

I’ll look into denormalizer and respond if I have any questions.

Thanks!