topic Summarize & Output Different Results in Alteryx Designer Desktop Discussions

Summarize & Output Different Results

sslattery17 — Tue, 05 Nov 2024 18:49:48 GMT

Request: Need help with approach or design, see screen shots of workflow and sheet names = (Properties).

Each of these properties include similar column data but several have a different calculation. Example: property 1 could be Rent = Rent + Storage, property 2 Rent = Rent + Storage + Parking, Property 3 Rent = Rent + Amenity Rent + Storage or Property 4 Rent = Rent

Workflow is built to bring in all the properties, generate all the columns currently; now just trying to figure out best approach to get each property output with the appropriate calculations without building a separate workflow. Any suggestions welcome.

Re: Summarize & Output Different Results

CoG — Tue, 05 Nov 2024 19:38:55 GMT

Do you have a data source that indicates what values contribute to total Rent? I'm thinking of a table with the following information:

Property	Field
Prop #1	Rent
Prop #1	Storage
Prop #2	Rent
Prop #2	Storage
Prop #2	Parking

Transpose the main data on all relevant rent fields, and join to the above dataset. Summarize Tool will calculate total Rent.

Please provide more specific info (including sample data) for more specific assistance.

Hope this helps and Happy Solving!

Re: Summarize & Output Different Results

nagakavyasri — Tue, 05 Nov 2024 19:45:03 GMT

@sslattery17 As per my understanding, I think you are looking to write output to multiple sheets. Consider the field which has the differentiating column and try this:

Re: Summarize & Output Different Results

sslattery17 — Tue, 05 Nov 2024 19:50:56 GMT

@CoG

I have attached a zip file with dataset workflow etc...I currently do not have a table (key) that shows what each properties customization is; but could easily create one since the client sends us this data. (I attached a sample of what I was starting to create).

Re: Summarize & Output Different Results

sslattery17 — Tue, 05 Nov 2024 19:56:45 GMT

@nagakavyasri yes partially what I am looking for. I already have my output file configured to output by property; but I also need to have a different calculations/summarization by property.