Mapping Table Excel

[gdilullo]

I have a problem with a mapping table. I have an Excel table that is loaded into a QlikView project, it's used it to create groupings.

In practice:

The first 3 columns are taken from the DB, the third is assigned in the excel file.

Then:
  - Loads the data from the DB
  - Loads the mappings excel
  - Remaps(Raggruppamento) the triples(Cond.Contrattuale-Posizione-AreaProfessionale) in a pivot table.

The problem is when the same subject A belongs to two different groupings(Raggruppamento)
For example:

     - Dipendente - Segreteria - Non Professionale - Supporter e amministrativi

     - DIpendente - Consulente - Legale - Consulenti e Assistenti

in the pivot table shows only one of the two triples (the most recent in chronological order).

Does anyone have an idea? It must use a "mapping table" or something like this?

Thanks

Beppe

[#2]

I think it's because I embedded an external link! Great minds and all...