topic Re: Return a selected column name from graph builder in Discussions

Return a selected column name from graph builder

shampton82 — Fri, 09 Jun 2023 23:42:04 GMT

Is there a way to return the selected column from the column list in graph builder when you run a script? For example, if I were to have selected age in the column list:

and then run a script, would I be able to get the age column name and use it? The reason I ask is that I have "shortcut" scripts that help with data clean up. I often see issue in graph builder and then run a script that asks me to select the column I want to modify, however this is actually redundant as I had already selected the column in graph builder. So if I could have the script grab the name of the selected column in the graph builder column list I could avoid some extra input boxes and clicks.

Thanks for any ideas!

Re: Return a selected column name from graph builder

txnelson — Sat, 31 Oct 2020 18:26:47 GMT

This JSL will return the value selected in a Graph Builder dialog box

variable = Current Report()[listboxbox( 1 )] << get selected;

Re: Return a selected column name from graph builder

shampton82 — Sat, 31 Oct 2020 18:37:29 GMT

Perfect! Thanks so much for a quick reply.

Have a good day!

Re: Return a selected column name from graph builder

shampton82 — Sat, 31 Oct 2020 18:40:38 GMT

Playing around with this, I am now wondering is there something similar for the column switcher box?

Re: Return a selected column name from graph builder

txnelson — Sat, 31 Oct 2020 19:54:25 GMT

The same JSL will work if a Column Switcher is invoked. It will return the selection from the Column Switcher.
Do you understand what the line of JSL is doing?
I suggest that you read the documentation in the Scripting Guide, on Display Trees.

Re: Return a selected column name from graph builder

shampton82 — Sun, 01 Nov 2020 03:32:19 GMT

Thanks for the additional info and no I don’t understand it yet but plan on getting there. I’ll review the info you suggested. Thanks again.

Steve

Re: Return a selected column name from graph builder

Mark_Bailey — Mon, 02 Nov 2020 09:59:49 GMT

To @txnelson's point, the documentation and the Scripting Index will inform you that the Column Switcher is an object with its own protocol, including the message << Get Current specifically for your need.