This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have 2 inputs. One is a typical Data file with dimension and measure columns and the other one is configuration file. This configuration file has a column which specifies a column name from Input 1 for which a Group by summarized output is expected. The configuration file will have multiple rows which I will loop through and generate Summarized Group by Result for the column.
I want to be able to dynamically select the column from Input 1 in Summarize tool which is specified in Input 2.
How about a batch macro to edit the XML of a Summarize tool:
Also attached is a workflow with some example uses. Grouping does need to be specified, and you will need to know the Action code. To get the desired Action code, we can view the XML of a configured Summarized tool. To enable this option in the Configuration, check the box for: Options -> User Setting -> Edit User Settings -> Advanced -> Display XML in Properties Window
I figured it out myself using Dynamic Rename Tool. So from Input 2 I rename my column using the option Take Field names from right Input Rows and then specify the Old and New column Names. Worked perfect for me.