Filter column using List box

[johnnyacm]

Hello Community

I have the following challenge, I need to filter some columns from my input data in analytic app, the idea is the usser can choose the column, those fields will have some internal calculations , I have been reading and I know is using list box and dynamic select, but I am new in this i will appreciate some help or guides

[OTrieger]

@johnnyacm 

There are several ways to do it. one of the is as described bellow, using the tools that you indicated:

You will need to have in the User Interface List Box tool containing all the available fields. Connect it to Text Input tool and replace the text in the cell so the list will be entered to that cell. Then connect tit to Text to Columns tool, indicating the delimiter and you will need to solid the data to rows. Add a Formula tool and add a Header named Description with a specific text such as Keep, Need, etc.

Connect the input data to Data Info Tool. Join the 2 strings based on the Name of the Headers. in the J output you will have all the selected fields for calculate selected by the user.

Now connect the input data tool to Dynamic Renaming Tool and then connect the results form the Joining tool. Set the Dynamic renaming tool to its last option, Update Description from first row. And add Dynamic select tool with the formula [Description] = the word that you used earlier. That will leave you with the fields that are needed for calculation.

Now how to set dynamic calculation formulas is depends on the type of calculations needed. Now that might varied significantly as based of the required calculation  as these fields will need to be selected as variables, however without knowing which calculations will be done it will be hard to continue with the solution from this point.

Hope that this gave you some help with what you are facing.

[johnnyacm]

I did it, but is not working :C

[OTrieger · Accepted solution]

You did not follow the full instructions. Check the attached WF. Just for the shake of the demo I entered the values manually to the Box List Tool, you can connect also external file that containing all the headers. Again there are several ways on how to get them from the input file and get updated into the Box List Tool

[johnnyacm]

you are a genius thank you very much