Hi Nicola,
An IntervalMatch in your load script will do what you need. Add this after Tables A & B are loaded:
IntervalMatch:
IntervalMatch(ID2) LOAD [First ID2],[Last ID2] Resident TableA;
This will give you a data model with a synthetic key. DON'T WORRY. Unexpected synthetic keys in your data model are often a sign of a defect in your script and they may cause performance problems. This is not the case when a synthetic key is created by the Intervalmatch function - this is normal and you need not add lines to your script to remove it. It's fine.
This is the result shown in a tablebox:
| ID2 | Descriprion2 | Amount | Group | ID | Descriprion |
|---|
| 0602000001 | … | +1236,55 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000002 | … | +1244,00 | | | |
| 0602000003 | … | +123,56 | | | |
| 0602000004 | … | -125,15 | | | |
| 0602000005 | … | -12,18 | | | |
| 0602000006 | … | +13985,87 | | | |
| 0602000007 | … | 0 | | | |
| 0602000008 | … | 0 | | | |
| 0602000009 | … | 0 | | | |
| 0602000010 | … | 0 | | | |
| 0602000011 | … | 0 | | | |
| 0602000012 | … | 0 | | | |
| 0602000013 | … | 0 | | | |
| 0602000014 | … | 0 | | | |
| 0602000015 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000016 | … | 0 | | | |
| 0602000017 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000018 | … | 0 | | | |
| 0602000019 | … | 0 | | | |
| 0602000020 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000021 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000022 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000023 | … | 0 | SP330SP360 | 70000 | ALTRI CREDITI |
| 0602000024 | … | 0 | | | |
| | | | SP330 | 95000 | CREDITI VERSO SOCIETA DI PROPRIETA' |
| | | | SP350 | 90000 | EFFETTI ATTIVI IN PORTAFOGLIO |
Kind regards
Andrew
