GL account and INTERVALMATCH question

[amien]

interval:

LOAD * INLINE [

    GL_text      , GL_from ,  GL_to   

    first            , 10000, 20000

    second       , 20000, 30000

    third           , 40000, 50000   

];

Is use this function to put all GL accounts in a certain category (GL_text).. works great ..

but for some reports i need this function too, but with an extra dimension.

Each GL account has a code .. and based on that code, the need need to be in a certain category (GL_text)

and its mixed .. for some GL accounts the code is not taken into consideration .. but for others it is .. so its mixed.

So, i have this table

GL_account , code

20000          , X1

20000          , X2

GL account 20000 and X1 should have a GL_text of 'forth'

and GL account 20000 and X2 should have a GL_text of 'fifth'

How can i solve this?

[stephencredmond · Accepted solution]

Hi Amien,

Do you know that IntervalMatch can accept additional "keyfield" parameters (look for "IntervalMatch (Extended Syntax)" in the help file.

That might work for you?

Regards,

Stephen