Forum Discussion

haleswd258's avatar
haleswd258
Regular Visitor
4 years ago
Solved

Dynamic Table Diff

I have a Sales Table that lists part numbers that have been purchased.  I also have a Required Stocking Table that contains the part numbers and quantities that we require our customers to stock.  I ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi haleswd258 ,

     

    Here's my solution.

    1.Merge two tables.

     

    2.Expand the column.

     

    3.Replace the null in the Qty.1 column with 0

     

    4.Add a custom column to get the stock quantities.

     

    5.Remove the Qty column and the Qty.1 column. Rename the Custom column as the Qty column. You'll get the following.

    Filter out the Qty=0.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi haleswd258 ,

 

Here's my solution.

1.Merge two tables.

 

2.Expand the column.

 

3.Replace the null in the Qty.1 column with 0

 

4.Add a custom column to get the stock quantities.

 

5.Remove the Qty column and the Qty.1 column. Rename the Custom column as the Qty column. You'll get the following.

Filter out the Qty=0.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.