User interface for select tool

Namshad

Hi All,

I am trying to give an interface for select tool, Please find the attached workflow.

Here I am selecting the required columns using list box, users can select which specific columns they require to be outputted and it is working. But how can I deselect some specific columns using a user interface, that is all columns should be outputted except those are selected by the user.

workflow.yxwz

Thableaus

Hi @Namshad 

Here's an approach:

- You need to change the Select Tool Mode to Generate a Custom List - watch out you need to leave "Start" and "End" in blank and "Separator" as a single comma (,).

- Then, for the action Tool, you need to update the Raw XML with a formula:

' <SelectFields>
<SelectField field="' + replace(EscapeXMLMetacharacters([#1]), ",", '" selected="False" />
<SelectField field="') + '" selected="False" />
<SelectField field="*Unknown" selected="True" />
</SelectFields>'

This is a tough Formula to understand at first. But the main part of the formula resides here:

replace(EscapeXMLMetacharacters([#1]), ",", '" selected="False" />
<SelectField field="')

Basically, imagine that the list of fields to be deselected will come like this if the user selects the first 4 of them in the List Box interface.

Emp_ID, Emp_Name, Age, salary

This part of the formula is replacing the comma (,) between each field by this expression

" selected="False" />
<SelectField field="

It's basically closing out the expression that deselects a Field (changes it to False) and then starts the following after that.

It's a little bit hard to understand, but it works fine.

See attached.

Cheers,

workflow_solution.yxwz