Update Unique Tool Via Action Tool

[fimler]

I am creating a gallery app that will allow users to filter a large data set down to data they need and then download that data.  Because I am allowing the users to select the fields they want in the dataset they download, there will most-likely be duplicate rows.  How can I update the Unique to Select All of the fields that are passed into it from an upstream Select tool?  

[apathetichell]

If you post parts of your workflow I'm sure it's doable via listbox/action/unique (or filter). You can should be able to toggle the unique selections with the listbox input. It might take some workarounds but it's doable.

there's always the transpose and then put the unique tool in a batch macro where you feed in the data grouped by the original fields now in the [name] column. Then you can crosstab everything either in the batchmacro (making sure you have your interface designer ouptut set for the right options) or once you are back in your macro.

[atcodedog05 · Accepted solution]

Hi @fimler 

Here is how you can do it.

1. I am using list box on select tool mode to select fields.

2. I am using the list box selection to pass it to unique tool. In action tool for unique tool i am configuring as below.

action type is Update Field List and update is Unique Fields

Output: Case 1

    

Output: Case 2

 

Test around with this approach and let me know

Hope this helps 🙂

[fimler · Accepted solution]

This is exactly how I had it configured but I had forgotten to check the “Select All” checkbox (ughhh). Thank you for your reply. It at least confirmed that I had it configured correctly.