Hello - I'm very new to Power Pivot and I'm guessing there must be an easy solution to this that I'm just not aware of but I haven't had any luck finding out the best way to handle this.
I set up a relationship between two tables with a common column "Unit ID #".
The first table is the list of the unique unit Unit ID #'s with some additional descriptive data. There are about 250 rows for each unit and it is manually updated when new units are added.
The second table is a large data dump out of another database with multiple lines for each Unit ID #. There are 5,000+ rows in this table.
The pivot that I'm using basically merges the descriptive data from the first table to the data in the second table. The problem that I'm running into is that the second table could include brand new Unit ID #'s each month...usually there's not a lot but there could be 1-5 new ones each month. And since the first table with the unique Unit ID #'s is a table that needs to be manually updated when new units are added, the pivot isn't finding the unit ID #/descriptive data for the new units that have been added in the large table. They show up as blank.
So I guess my question is - is there anyway to some how highlight or quickly locate new unit numbers that been added in the large data table (second table) that *DO NOT* have a corresponding matching unit ID in the first table? Just looking for a relatively easy way to identify any new units from the large table to signal that they need to be manually added to the table with the unique list of units and from there I can refresh so that all are finding a match.
I hope my question makes sense! I appreciate any thoughts/input.
Chris
I set up a relationship between two tables with a common column "Unit ID #".
The first table is the list of the unique unit Unit ID #'s with some additional descriptive data. There are about 250 rows for each unit and it is manually updated when new units are added.
The second table is a large data dump out of another database with multiple lines for each Unit ID #. There are 5,000+ rows in this table.
The pivot that I'm using basically merges the descriptive data from the first table to the data in the second table. The problem that I'm running into is that the second table could include brand new Unit ID #'s each month...usually there's not a lot but there could be 1-5 new ones each month. And since the first table with the unique Unit ID #'s is a table that needs to be manually updated when new units are added, the pivot isn't finding the unit ID #/descriptive data for the new units that have been added in the large table. They show up as blank.
So I guess my question is - is there anyway to some how highlight or quickly locate new unit numbers that been added in the large data table (second table) that *DO NOT* have a corresponding matching unit ID in the first table? Just looking for a relatively easy way to identify any new units from the large table to signal that they need to be manually added to the table with the unique list of units and from there I can refresh so that all are finding a match.
I hope my question makes sense! I appreciate any thoughts/input.
Chris
