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

Merging of two different data with few different columns

NehaNevrekar
8 - Asteroid

Hi,

 

Please guide us on how to merge two different sheet in two different workbook. Please find below the e.g. for your reference.

 

Please also tell us how to merge the sheet if the two sheets is in the same workbook assuming the same data. Attaching the working for your reference.

 

Data 1 

NameAddressInvoice NumberInvoice dateTaxable valueTax
AMumbai125-05-20100050
BDelhi222-05-2050025
CKolkata319-05-20150075
DBangalore412-05-202000100
AMumbai519-05-203500175
BDelhi616-05-205500275
CKolkata713-05-209000450
DBangalore812-05-2014500725

 

 

Data 2

 

NameAddressTax Registration NumberInvoice NumberInvoice dateInvoice receipt dateTaxable valueTax
AMumbai100003456789003125-05-2027-05-20100050
BDelhi100003456788003222-05-2024-05-2050025
CKolkata100003356788003319-05-2021-05-20150075
DBangalore100003346788003412-05-2014-05-202000100
AMumbai100005346788003519-05-2021-05-203500175
BDelhi100003546788003616-05-2018-05-205500275
CKolkata100003646788003713-05-2015-05-209000450
DBangalore100053346788003812-05-2014-05-2014500725

 

Thank you in advance.

 

Regards,

Neha

3 REPLIES 3
KK12
7 - Meteor

Hi Neha,

 

I have attached the solution for you.

If the input is in different files, give the reference of that file in input tool. If the input is in 1 file but different sheets, select different sheets in two input tools and then apply join.

Use the join tool. See the way I have done configuration of join tool. I have deselected the common columns from the right file so that they don't appear twice in the solution.

 

Let me know if you have further questions.

 

Thanks,

Kirti khetrapal

echuong1
Alteryx Alumni (Retired)

Each input needs to have a separate Input Data tool. This is true if the data is in the same file and just on different sheets, or if the data is in different files entirely.

 

When you are merging the data, it depends on how you want to merge the records.

 

If you want to do more of a "vlookup" type function where you have matching values/criteria, and you're looking to add additional information, you would use a Join tool.

 

If you want to append the records on top of each other to create a "master list" and simply match the common columns, you can use a Union tool. This will include all columns from both datasets and match the common ones together, and include records for the unmatched columns when available.

 

Let me know if this helps!

 

echuong1_0-1593289323475.png

 

NehaNevrekar
8 - Asteroid

Hi Kirti,

 

Thanks for your reply. I will surely try the solution given by you and get back to you in case of any query.

 

Regards,

Neha

Labels