Free Trial

Alteryx Designer Desktop Discussions

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

Subtraction between 2 spreadsheets

O675379
5 - Atom

I am importing 2 spreadsheets into a project.  Both sheets have the same column names and several of the same values in the columns except for a column called count.  I'm looking to subtract the count from sheet 2 from the count in sheet 1 where all of the colums

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@O675379 
It will be better if you can provide a sample input and output?

ArtApa
Alteryx
Alteryx

Hi @O675379 - You'd need something like this:

ArtApa_0-1645671177970.png

 

KamenRider
11 - Bolide

Hi @O675379 

 

Please provide screenshots or attached your input files for reference. Surely our experts here could provide you the solutions you're looking for.

 

regards,

Kamen

Labels
Top Solution Authors