combine monthly sales (P&L) into one spread sheet

[ksarker]

how to combine monthly sales or P&L information into one spread sheet. 

June Sales 

last name	first name	zip code	state	product	June Amount
Smith	John	1234	NY	Apple	50,425
Weber	David	3214	FL	orange	45,789
Rosa	John	4321	NJ	Milk	25,489

July Sales 

last name	first name	zip code	state	product	July Amount
Smith	John	1234	NY	Apple	45,428
Weber	David	3214	FL	orange	35,780
Rosa	John	4321	NJ	Milk	48,459

i would like to combine these two months sales reports into one such as 

last name	first name	zip code	state	product	June Amount	July Amount
Smith	John	1234	NY	Apple	50,425	45,428
Weber	David	3214	FL	orange	45,789	35,780
Rosa	John	4321	NJ	Milk	25,489	48,459

[Emil_Kos · Accepted solution]

Hi @ksarker,

Join tool will work perfectly here.

Please find a solution attached. 

[atcodedog05 · Accepted solution]

Hi @ksarker 

Here is the workflow for the task.

Output:

Workflow:

Joining on all columns expected monthly

Join tool interactive lesson https://community.alteryx.com/t5/Interactive-Lessons/Joining-Data/ta-p/76634

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @ksarker 

Cheers and Happy Analyzing 😀