topic Re: Interval Match in App Development

Interval Match

americanetsMD — Wed, 25 Oct 2023 12:56:08 GMT

Hello everyone,

I have a new task and in order to achieve my goal i have to add all Kontos to the Groups, based on specific Intervals.

With this said, i will now show you what tables i have, and where i need to get.:

I have the following Tables:

SetTab:

Load

KontoFrom,

KontoTo,

SetName

Resident SetSource;

KontoTab:

Load

Konto

Resident KontoSource;

In the SetTab i have following data (Example):

KontoFrom | KontoTo | SetName

00100 | 00199 | Set1

00200 | 00299 | Set2

00100 | 00299 | Set3

In the kontoTab i have following data (Example):

Konto

00101

00120

00201

00222

Now, what i need is to assign each Konto to the Set (SetName) based on the Intervals (KontoFrom / KontoTo)

I have to get something like:

SetName | Konto

Set1 | 00101

Set1 | 00120

Set2 | 00201

Set2 | 00222

Set3 | 00101

Set3 | 00120

Set3 | 00201

Set3 | 00222

I have already tried the Interval Matching but i get an all to all connection... 😞

I will be really thankful when someone can suggest how can i achieve this result.

Re: Interval Match

PrashantSangle — Wed, 25 Oct 2023 13:24:59 GMT

Try below

Script

SetTab:

Load Num(KontoFrom) as KontoFrom, Num(KontoTo) as KontoTo,SetName Inline [

KontoFrom,KontoTo,SetName

00100,00199,Set1

00200,00299,Set2

00100,00299,Set3

];

NoConcatenate

SetFinal:

Load *,

KontoFrom + IterNo() - 1 as newTo

Resident SetTab

while KontoFrom + IterNo() - 1 <= KontoTo;

KontoTab:

Load Num(Konto) as newTo,'kontoTab' as flag Inline [

Konto

00101

00120

00201

00222

];

drop Table SetTab;

Visualization

Regards,

Prashant Sangle

Re: Interval Match

americanetsMD — Tue, 31 Oct 2023 16:28:15 GMT

Hi PrashantSangle,

Thank you very much for your help. I have got it done. 🙂