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?
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.