Joining for specific outputs

[Cheric]

I joined two datasets successfully on one common field.  However, I want to modify the output to contain certain details only.  E.g. I joined on invoice number, but I need the output to tell me what the sales, cost of sales and inventory amounts were.  What's the best way to do this?

[atcodedog05]

Hi @Cheric 

Its bit unclear can you please give a sample data, excepted output and explain the logic.

[Aaron_Harter]

Hi @Cheric

You can use the embedded Select tool functionality to de-select the fields you no longer need after performing the Join:

[Cheric]

What I am trying to do is to compare two datasets for which the common field is the invoice number.  When finding the invoice number contained in dataset 1 in the second dataset, I wish the output to look whether there are fields for sales, cost of sales and inventory in dataset 2.  If not, the output should only be the exceptions.

I think I am using the incorrect tool - perhaps join is not the way to go.  This will be my first workflow...

[Qiu]

@Cheric 
so basically you want to check if fields for sales, cost of sales and inventory are present in dataset 2?

Like @atcodedog05  mentioned, a sample input and output would be helpful for us to understand the requirement here.

[atcodedog05]

Hi @Cheric 

We have a very rough idea of the data. Can you please provide a sample

As @Qiu said it will become very helpful to us if you can provide a 5 rows sample data with expected output

[Cheric]

I attached the Excel version - where I manually compared the data.  I want the workflow to check that every entry in dataset 1 has a corresponding sales, debtors, VAT, cost of sales and inventory entry in dataset 2.  If it has, then there will be no output.  But, if it misses any of those entries, then the output should be the exceptions only.

[Qiu]

@Cheric 

I hope I get it right. wait for your comment.