Range from to

[bmensing]

Dear Community,

my data model is like

Measure table:

id        article

1         hat

2         dog

3         cat

4         lorry

5         car

6         skirt

7         jeans

8         belt

9         bird

10       Lion

fact table:

id min          id max       describtion

1                   1               clothing

6                   8               clothing

2                   3               animals

9                  10              animals

4                   5               others

i Need to connect These two tables and the difficult one is the id 7 which is not listed in my fact table, but Need to be connected as well... any ideas?

*EDIT* one more Information, that is very important --> the relation between the tables is 1 to n, like one id in the measure table can

be for example clothing and animals...

[YoussefBelloum]

Hi,

what is the key between these two tables ?

[fvelascog72]

Hi,

You can try with:

IntervalMatch

Saludos.

[antoniotiman]

May be this

LOAD * Inline [
id, article
1, hat
2, dog
3, cat
4, lorry
5, car
6, skirt
7, jeans
8, belt
9, bird
10, Lion];

facttable:
LOAD * Inline [
id min, id max, describtion
1, 1, clothing
6, 8, clothing
2, 3, animals
9, 10, animals
4, 5, others];

IntervalMatch (id) LOAD [id min],[id max] Resident facttable;

[bmensing]

that Looks good to me, but unfortunately i missed that there is an 1 to n relation like

the id 1 could also be clothing and others...

[MK9885]

id 1 doesn't seem to have any relation to others in your data. It is just linked to clothing.