Joining for specific outputs

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?

Output

Join

Accepted answers

All comments

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...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703