Using Field Locations Instead of Field Name In The Pivot Component

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Chronoite
Posts: 1
Joined: Wed Feb 03, 2021 10:55 pm

Using Field Locations Instead of Field Name In The Pivot Component

Postby Chronoite » Sun Feb 14, 2021 11:11 pm

The Pivot component allows for entry of field name to select groupings for the desired pivot, but I have a graph run before it to create dynamic metadata. Is there a way to use the pivot component or have the same outcome as it with using field position (ex $in.0.3) instead of field name (ID Value)?

jandikovae
Posts: 55
Joined: Fri Nov 04, 2016 8:51 am

Re: Using Field Locations Instead of Field Name In The Pivot Component

Postby jandikovae » Tue Mar 02, 2021 10:27 am

Hi,

I believe that the most straightforward solution in a situation like this is to use a Reformat component ahead of the Pivot transformation process. I mean, the Reformat component can be also used to arrange metadata to the desired order: you can define metadata before Reformat and after Reformat and use the component itself to tell which field from the original metadata belongs to the which field from the new metadata structure.

That way, you can map the third input to whatever metadata field you like and then use the particular field in the Pivot component by its name.

Please give it a try and let us know if this resolves your issue or if I have misunderstood anything in your use case.

Best Regards,
Eva
---
Eva Jandikova
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com