Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Deduction between Data A and Data B

SH_94
11 - Bolide

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

 

6 REPLIES 6
Emil_Kos
17 - Castor
17 - Castor

Hi @SH_94,

 

I have prepared a workflow for you:

 

Emil_Kos_0-1615055172389.png

 

THe output:

 

Emil_Kos_1-1615055179855.png

 

 

SH_94
11 - Bolide

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
20 - Arcturus
20 - Arcturus

@SH_94 
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

SH_94
11 - Bolide

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

 

SH_94
11 - Bolide

Hi @Qiu,

 

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

 

Thanks a lot for your help

Emil_Kos
17 - Castor
17 - Castor

Hi @SH_94,

 

Happy that you Solved it!

Labels