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?
Solved! Go to Solution.
@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?
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.
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
i think this is a easy logic of join tool .if you are facing any issue kindly share data for both of the stores