Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I will need to take a closer look at the example code you provided, it is a bit above my skill level so I need some time to understand it 
. In the meantime I think I found a solution in the document you linked to but I choose method 3 on page 6 that says "Don’t use this method unless you have very small tables". I will see if I can learn more during the weekend.
//Ola
Ola,
script works and:
tmp_f: load 0 as VERID AutoGenerate(0);
//prepares empty table (to have it for 1'st join)
for i=1 to 7
//we have 7 keys, so we need to deal with each of them
//we join into existing tmp_f table (this is why i created it over loop)
join(tmp_f)
load ACCODE0$
as ACCODE, VERID Resident FACT;
//ACCODE0$(i) gives column ACCODE01,2,3... depending on iter number
tmp_i:
load ACCODE0$(i)_START as start, ACCODE0$(i)_END as end, CATEGORY as cat$(i), Autonumber(Num(ACCODE0$(i)_START) & '|' & Num(ACCODE0$(i)_END)) as IntervalID Resident inter;
//into tmp_i table i load i'th range boudary (columns ACCODE0$(i)_START and ACCODE0$(i)_END), but i create //from them key (interval_id) for each row
bridge:
IntervalMatch ( ACCODE ) load distinct start,end Resident tmp_i;
//create table by intervalmatch (ACCODE is key from tmp_f table used for this iteration , start and end are range //from tmp_i (temporary interval) for this iteration
//and we have to clear what our interval produces, because we would like to have only tmp_f table when we start //next iteration in our loop.
Join (tmp_f)
Load ACCODE, Autonumber(Num(start) & '|' & Num(end)) as IntervalID
Resident bridge;
Drop Table bridge;
Join (tmp_f) LOAD cat$(i), IntervalID resident tmp_i;
drop table tmp_i;
drop fields ACCODE,IntervalID;
NEXT;
//after last one iteration we should have tmp_f table where we have 7 category columns (cat1,cat2,....cat7)
//you may comment instructions under and look on it in your application.
//from this table we will check if all 7 cat have the same value.
//if max=min then all existing values must be the same.
//so, we need only check if the 7 cat have values (no nulls) and we may decide to give category for fact. Knowing //that all cat fieldsghave the same value i take first, so, my result is cat1 
load VERID, if(RangeMaxString(cat1,cat2,cat3,cat4,cat5,cat6,cat7)=RangeMinString(cat1,cat2,cat3,cat4,cat5,cat6,cat7) and RangetextCount(cat1,cat2,cat3,cat4,cat5,cat6,cat7)=7, cat1) as category Resident tmp_f Where Exists(VERID);
drop table tmp_f;