hi,
just wonder if there is a way to only select group-by columns without using transpose and crosstab.
Note: the numeric fields are all set and static regardless of group-by field.
thank you!
Here's a sample of what you'd have to do.
Say I have a table connected to a Summarize tool:
If you look at the XML of the Summarize tool (by clicking on the XML icon on the config pane) you see this:
What you want to do is build your own XML to overwrite this. So if I want just Address and Zip to be grouped on, the XML would have to look like this:
<Configuration> <SummarizeFields> <SummarizeField field="Address" action="GroupBy" rename="Address" /> <SummarizeField field="ZipCode" action="GroupBy" rename="ZipCode" /> </SummarizeFields></Configuration>
You would connect an action tool to the Summarize tool and configure it like this:
The tricky part is the selections from the list box come in like this:Name=False,Address=True,ZipCode=True
So you have to build the XML within the action tool so that it comes out like the blue above. I'm not an XML expert or RegEx expert, but I think you'd have to make use of those functions.
But, if you can get that XML into the action tool:
Then the summarize tool will be configured as such when it runs.
Hope this helps!
Not too sure I get what you are trying to achieve.
Have you tried groupby in Summarize tool?
Best,
Seinchyi
Sorry for not getting this clear. i actually want a macro to do it.
