ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

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

Deduction between Data A and Data B

Jcsh_66
8 - Asteroid

Hi Community ,

 

May i know if there is better and faster way to build the workflow to obtain result below? Basically, Data A will minus Data B (for those invoices appear in both data) which will produce the final result. However, for those data A not appear in both side , will be captured as well in the final result.

 

Jacob_94_0-1615051609129.png

 

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

I have prepared a workflow for you:

 

Emil_Kos_0-1615055172389.png

 

THe output:

 

Emil_Kos_1-1615055179855.png

 

 

Jcsh_66
8 - Asteroid

Hi @ Emil_Kos,

 

Thank you for your prompt response.

 

I had done the same to my workflow and below is the output review in Alteryx.It seem like the data cannot appear in the same column. Do you know how to fix it?

Jacob_94_0-1615078559558.png

My Workflow Alteryx

Jacob_94_1-1615078593334.png

 

 

Qiu
17 - Castor

@Jcsh_66 
Can you check the option in your union tool?

In this case, it should be Auto Config by Name, since the two columns are having same name.

Union.png

Jcsh_66
8 - Asteroid

Hi @Qiu,

 

Yup.It is config by name as shown in the screenshot below.

 

May i know what are the other possibilities?

Jacob_94_0-1615085418555.png

 

Jcsh_66
8 - Asteroid

Hi @Qiu,

 

I managed to combine it after deleting the spacing in the words

 

Thanks a lot for your help

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

Happy that you Solved it!

Labels