topic linking two tables with multiple in App Development

linking two tables with multiple

prashantsharma8837 — Fri, 15 Nov 2024 21:32:49 GMT

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

Re: linking two tables with multiple

Mark_Little — Tue, 25 Jul 2023 09:36:33 GMT

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

Re: linking two tables with multiple

prashantsharma8837 — Wed, 26 Jul 2023 05:49:58 GMT

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.