In Workshop - Pivot table widget: How can values be copied

[vip_001]

I’ve created a pivot table, but need to know how to copied selected value from mentioned pivot table.

Need alternativ solutions, if this function is not supported at moment

[maubert]

Hello,
Indeed, the functionality is not supported yet.
Are you trying to copy the aggregation result (count, sum etc) or the grouped by value? If the latter, then as a workaround, you could try this out:

• From the pivot table widget, you can configure an output filter variable (so that when you click on a row, it triggers a filter variable). You can then use that variable on an object set that is clean from any other filter.
• Then you use the Exploration Filter Pills widget and put it just above/below/next to the Pivot Table.
  Hence everytime, you click on a row (or several), that widget will show as “property X is Y”, which will be displayed as text. You can then copy that “Y” value and paste it anywhere you want (inside or outside Foundry).

It is cumbersome and might not fit your workflow but this is at least what has worked ok for me, while waiting for that feature to be implemented natively.

Max

[vip_001]

Hi @maubert
Thanks for replying.

Tried your approach, but maybe I need a step-by-step guide with print screens for this to work.

I tried also pivot table filter output that contains the value I need, but dont understand why the filter output cant be used again directly as new input variable

My quick solution as for now:
I add just a empty string variable and used it as filter input in Object set Definition, so that end-users can just manually enter values from pivot table.

[maubert]

In this example, I have put in a Pivot Table the number of airports by State (in the US).
As you can see, I defined a filter output.

Then I used that variable to filter a new object (not the one that is input for Pivot Table)

Last I use the Exploration Pills Widget to show what has been filtered. And from there I can copy the text.

It is not ideal but at least this allows users to click on the pivot table and select then the text that appears and paste it somewhere else