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)?
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