Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Subtract contents in the same column

Polite123
8 - Asteroid

Hello Experts,

 

I need some quick results to subtract data in the same column as shown below:

 

Input data:

 

A BCD
78910
1234

 

 

Output data:

 

A BCD
78910
1234
6666

 

 

 

Thanks in advance.

 

 

5 REPLIES 5
AngelosPachis
16 - Nebula

Hey @Polite123 

 

I believe the following workflow does what you are looking for.

 

Screenshot 2020-10-06 162105.jpg

 

 

 

 

 

 

 

 

Hope that answers your question.

 

Cheers,

Angelos

atcodedog05
22 - Nova
22 - Nova

Hi @Polite123 ,

 

Here is a workflow for the task.

 

Output:

atcodedog05_0-1601998201431.png

Workflow:

atcodedog05_1-1601998221039.png

 

 

Hope this helps 🙂

 

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

atcodedog05
22 - Nova
22 - Nova

Hi @Polite123 

 

If we were able to help you please mark post as solution🙂

Polite123
8 - Asteroid

Thank you both of you!!!!!It worked:)

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂

 

Cheers and happy analyzing 😀

Labels
Top Solution Authors