Dynamic Summarise: Error - 'No fields have been selected for output'

patel_bm

I am trying to build an application to help user select a file and select dimension and measure to produce summary.

See attached screenshots for the tools used. I am using a List Box each to select dimension and measures.

List Box tool uses 'Generate Custom List' option and has following configuration:

Start Text: <SummarizeField field="

Separator: " action="GroupBy" /> <SummarizeField field="

EndText: " action="GroupBy" />

Same configuration with Sum instead of GroupBy on Measure List Box.

The action tool has this formula and using 'Update Raw XML with Formula' and 'Update inner Xml' options.

if [#1] = '<SummarizeField field="" action="GroupBy" />' then '' else [#1] endif+'
'+

if [#2] = '<SummarizeField field="" action="Sum" />' then '' else [#2] endif

This causes error 'No fields have been selected for output'.

Please note if I change action tool option to 'Update outer XML' it leads to error 'This tool has not been configuredWorkflowError

patel_bm

Hi Charlie

This works now.

however I have also managed to get the application workflow to work with List tool.

List Box tool uses 'Generate Custom List' option and has following configuration:

Start Text: <SummarizeField field="

Separator: " action="GroupBy" /> <SummarizeField field="

EndText: " action="GroupBy" />

Same configuration with Sum instead of GroupBy on Measure List Box.

The action tool has this formula and using 'Update Raw XML with Formula' and 'Update inner Xml' options.

if [#1] = '<SummarizeField field="" action="GroupBy" />' then '' else [#1] endif+'
'+

if [#2] = '<SummarizeField field="" action="GroupBy" />' then '' else [#2] endif

It seem to be working fine now.

Here's the screenshot.