Join tool set up configuration to view no duplicate rows

I am comparing produce inventory between two stores. Each store is completing an inventory profile as shown below, refer to screenshot. How should I setup the join tool to view the quantity on hand and quantity sold last week for each store, to have no duplicate rows?

Workflow

Datasets

Accepted answers

ShankerV

Hi @MannySantibanez123

A small advancement, as displaying the result should be clear for everyone while reading the data.

Hence added dynamic rename tool to display the column name as Store 1 and Store 2 respectively.

Many thanks

Shanker V

Dynamic rename Join tool set up configuration to view no duplicate rows.yxmd

All comments

Qiu

@MannySantibanez123
It seems that there is only data for one store in your snapshot?

Can you provide the data for 2 store in txt and also your expected output?

MannySantibanez123

The two stores in this case are identical, same data.

My expected output is to just have no duplicate rows when the data is joined with the join tool.

ShankerV

Hi @MannySantibanez123

One way of doing this.

Many thanks

Shanker V

Join tool set up configuration to view no duplicate rows.yxmd

ShankerV

Hi @MannySantibanez123

A small advancement, as displaying the result should be clear for everyone while reading the data.

Hence added dynamic rename tool to display the column name as Store 1 and Store 2 respectively.

Many thanks

Shanker V

Dynamic rename Join tool set up configuration to view no duplicate rows.yxmd

Raj

i think this is a easy logic of join tool .if you are facing any issue kindly share data for both of the stores

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703