Conception Idea

[#1]

Hello,

I have a file with the sales, in this file i have one field about the agent who provide the sale and a field about the agent who sale.

Table Sales :

ID_Sale

Id_Customer

Id_AgentA (provide Sale)

Id_AgentS (Sales)

...

I have also 3 more tables :  Agent, Service and Agency.

Actually i duplicate this 3 tables and i have a link for the Id_AgentA and Id_AgentS.

I wanted to know if someone has a solution for no duplicate this 3 tables.

Thank you and sorry for my english 😉

[MarcoWedel]

Hi,

I guess you could apply the methods described here:

Canonical Date

Why You sometimes should Load a Master Table several times

hope this helps

regards

Marco

[ElizaF]

Hello Hamza,

I suppose that you duplicate the tables for information like agent name etc.

In this case you can use the applymap function.

Agent_Map:

Mapping

Load

Id_Agent,

Name;

Sql ID_Agent, Name from Agent;

Sales:

Load

ID_Sale,

Id_Customer,

Id_AgentA,

Id_AgentB,

ApplyMap('Agent_Map',Id_AgentA,'N/A - Id_AgentA Name') as Id_AgentA_Name.

ApplyMap('Agent_Map',Id_AgentB,'N/A - Id_AgentB Name') as Id_AgentB_Name

...

Please let me know if i understand correct and the solution help you.