Two different files excel in one with additional info

[andreatorres]

Good afternoon i'm new using alteryx, and i'm trying to work with two different files from excel,

The file No.1 contain this information

Codice	Denomination	No. Invoice from other countries
5	Company X	25.000
4	Complany Z	85.000
9	Company Y	15.000

The file No.2 contain this information

Society	Ord num	Code	Denomination	Responsible
SErvices	60026926	60-2458-353	Company G	Lucas
SErvices	60026945	60-2458-224	Company X	Matteo
SErvices	60025685	60-2458-169	Company Y	Peter
SErvices	600264546	60-2458-698	Company L	Fernando

And i'm trying to obtain an unique file like this

Codice	Denomination	No, Invioce from other countries	Society	Ord Number	Code	Responsible	Cluster
5	Company X	25.000	SErvices	60026945	60-2458-224	Matteo
4	Company Z	85.000	SErvices
9	Company Y	15.000	SErvices	60-2458-169	60-2458-169	Peter

The unique file (file No1) has to get the information from file No.2 according the Denomination (company), with a new blanck column called Cluster

How can i get the right information from file no 2 and put it into the right company

 I'll appreciate if anyone could help me

[Thableaus · Accepted solution]

Hi @andreatorres 

Would this work?

1st Text Input - your 1st Excel File

2nd Text Input - your 2nd Excel File

3rd Text Input is your empty "Cluster" field. You can write that to a Text Input Tool.

You join 1st and second input and union the L side to J side. This is a left join.

Then you union that to the Cluster field, just to bring it as a blank field.

Workflow attached.

Cheers,

[andreatorres]

Thank you very much...it worked....

[andreatorres]

i have another question, can i join a work done with a new input data or i must use join multiple

[Thableaus]

@andreatorres 

Yes, you can get the output of your work done and join it to a new dataset.

Join multiple is used when you have a common key among multiple datasets you're working with and then you don't need to use the Join tool over and over again. You use a single one.

Cheers,