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 valueTaxAMumbai125-05-20100050BDelhi222-05-2050025CKolkata319-05-20150075DBangalore412-05-202000100AMumbai519-05-203500175BDelhi616-05-205500275CKolkata713-05-209000450DBangalore812-05-2014500725 Data 2 NameAddressTax Registration NumberInvoice NumberInvoice dateInvoice receipt dateTaxable valueTaxAMumbai100003456789003125-05-2027-05-20100050BDelhi100003456788003222-05-2024-05-2050025CKolkata100003356788003319-05-2021-05-20150075DBangalore100003346788003412-05-2014-05-202000100AMumbai100005346788003519-05-2021-05-203500175BDelhi100003546788003616-05-2018-05-205500275CKolkata100003646788003713-05-2015-05-209000450DBangalore100053346788003812-05-2014-05-2014500725 Thank you in advance. Regards, Neha Alteryx.xlsx

Merging of two different data with few different columns

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

Name	Address	Invoice Number	Invoice date	Taxable value	Tax
A	Mumbai	1	25-05-20	1000	50
B	Delhi	2	22-05-20	500	25
C	Kolkata	3	19-05-20	1500	75
D	Bangalore	4	12-05-20	2000	100
A	Mumbai	5	19-05-20	3500	175
B	Delhi	6	16-05-20	5500	275
C	Kolkata	7	13-05-20	9000	450
D	Bangalore	8	12-05-20	14500	725

Data 2

Name	Address	Tax Registration Number	Invoice Number	Invoice date	Invoice receipt date	Taxable value	Tax
A	Mumbai	100003456789003	1	25-05-20	27-05-20	1000	50
B	Delhi	100003456788003	2	22-05-20	24-05-20	500	25
C	Kolkata	100003356788003	3	19-05-20	21-05-20	1500	75
D	Bangalore	100003346788003	4	12-05-20	14-05-20	2000	100
A	Mumbai	100005346788003	5	19-05-20	21-05-20	3500	175
B	Delhi	100003546788003	6	16-05-20	18-05-20	5500	275
C	Kolkata	100003646788003	7	13-05-20	15-05-20	9000	450
D	Bangalore	100053346788003	8	12-05-20	14-05-20	14500	725

Thank you in advance.

Regards,

Neha

Alteryx.xlsx

Topic of Interest

Accepted answers

KK12

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

Solution.yxmd

All comments

KK12

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

Solution.yxmd

echuong1

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!

New Workflow8.yxzp

NehaNevrekar

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703