Summarize tool

[Feras95p]

Dear all,

How can I use more than one input in summarize tool? I want to input data from different sheets which have the same type of data into one summarize tool to have one output.

Thanks

[MarqueeCrew]

@Feras95p ,

 have you considered a UNION tool prior to the summarize?

 Cheers,

Mark

[Feras95p]

Hi @MarqueeCrew ,

I tried to achieve this but I couldn't if you can help me in this topic will be much appreciated.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-summarize-function/m-p/575674  

[MarqueeCrew]

Can you post the data?

[Feras95p]

I already posted the sample data file in this post

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-summarize-function/m-p/575674  

[MarqueeCrew · Accepted solution]

@Feras95p ,

Your challenge was really about the use of the UNION tool.  The three sheets contain similar data, but different schemas.

Sheet 1 contains "order number" and sheet 2 contains "order nymber"  and sheet 3 contains "order  number".  This is just one of the differences.

You need to use the "Manually configure fields" option to align the columns.

Cheers,

Mark