linking two tables with multiple

[prashantsharma8837]

Dear All,

I have two table one have (First Table) ZONE , REGION & TERRITORY. Another (Second Table) table have ZONE, REGION , TERRITORY , TYPE & VALUE.

WHY Zone & Region in Second Table :- Zonal Manager & Regional Manager fill their expenses & ID stores in ZoneID & RegionID in Second Tabel with FLAG (TYPE)

Problem :- If links the table with TerritoryID , wherever Zonal & Regional Managers enter their data & ID get stored individually, Hence TerritoryID is null at the places & data is cannot be mapped.

Customer Requirement : - Link both table with territory & get the output for Zonal Manager & Regional Mangers Value.

Attaching the Excel Data. Please Help

Thanks in Advance

[Mark_Little]

Hi.

At a quick glance i would look at splitting the second table into the tables.

Load 

ZoneID,

Type as Zone_Type,

Value as Zone_Value

Resident Table1

Where LEN(ZoneID) > 0;

repeat for the other IDs

[prashantsharma8837]

Hey mark,

Thanks for the solution, but i don't think that i can plot all three table into a single pivot with a single value field.