Filter column using List box

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

Workflow

Datasets

Developer

Developer Tools

Dynamic Processing

Accepted answers

OTrieger

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

Sample.yxwz

All comments

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

you are a genius thank you very much

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703