Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Map two tables with ranges

Hi,

I have two tables,

one with a list of AccoutsNo and Valus on each account

and another table with Acount Groups, AccountNoFrom, AccountNoTo

Now I don't know how to map this two together, Is there some one who have tip?

Many thanks in advance

Lars 

Tags (3)
1 Solution

Accepted Solutions

Re: Map two tables with ranges

Hi Lars,

One solution would be using the IntervalMatch() load. You can find a working example in this thread among many other posts in the Community.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

3 Replies
SunilChauhan
Esteemed Contributor

Map two tables with ranges

i dont know exactly but i think one of AccountNoFrom and  AccountNoTo

will be used as key

which is linked with AccoutsNo

Re: Map two tables with ranges

Hi Lars,

One solution would be using the IntervalMatch() load. You can find a working example in this thread among many other posts in the Community.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

Re: Map two tables with ranges

Many thanks Miguel,

It was a good exampel , Now I'm back on the road again

Community Browser