Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Summarize Tool when used it shortens Data ,

kumaneh
5 - Atom

Hi , Can anyone help how to combine rest data after Summarize tool , as summarize will shorten data but need to carry forward remaining data ?

4 REPLIES 4
Yoshiro_Fujimori
15 - Aurora

Hi @kumaneh ,

Can you provide a sample case which causes "shortened data", with the input data, the actual output and your expected output?

kumaneh
5 - Atom

Hi Sorry that little difficult to post here ,wanted to know after summarize tool how can connect restof data and carry forward alonf with result arrived in summarize tool.

apathetichell
18 - Pollux

Join the fields you are grouping by in your summarize tool to the original datastream via a join tool. If they are single values - use append fields.

Yoshiro_Fujimori
15 - Aurora

Hi @kumaneh ,

Is this what you mean?

 

Input

Field1
1
2
3

 

Output

Field1Sum_Field1
16
26
36

 

If so, you can add Append Field tool or Join tool, as @apathetichell suggested.

Here is a simplified workflow. Hope this helps.

 

Workflow

1286757_Workflow.png

Labels