Composite Points and Search Columns
A composite trick consists of several column. Information systems cant need composite important factors: a desk should posses exactly one line that exclusively identifies each line for the table. Should you decide import tables that have a current union based on a composite trick, the Table Import Wizard in Power Pivot will dismiss that partnership because it cant feel developed during the model.
To produce a relationship between two tables which have several articles defining the main and overseas tactics, 1st blend the standards to generate an individual trick column before producing the connection. This can be done just before transfer the information, or by generating a calculated line during the information unit by using the Power Pivot add-in.