Join tool set up configuration to view no duplicate rows

[MannySantibanez123]

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?

[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

[ShankerV · Accepted solution]

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

[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