Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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 

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

3 Replies
SunilChauhan
Champion
Champion

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

will be used as key

which is linked with AccoutsNo

Sunil Chauhan
Miguel_Angel_Baeyens

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
Author

Many thanks Miguel,

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