Differences

[prma7799]

Hi All,

what is difference between interval match and apply map?

Thanks

Prashant

[alexandros17]

Intervalmatch places values froma a table into corresponding intervals of a second table, while apply map places a field from a first table into a second table field (Not a Range of values - Interval)

take a look to the help for other details

Hope it helps

[avinashelite]

apply map will match for that particular ID and get you the result.

eg

table1:

maaping load

key,name

1,A

2,B

table2:

key,dept

1,XX

2,YY

when you use apply map

load applymap('table1',key) as name,

key,

dept

output

name,key,dept

A,1,XX

B,2,YY

interval will try to match for a range of values like from 0 to 5 its will search if any value is found it will provide the result

[#4]

Hi,

On broad line;

IntervalMatch() function is like matching the ranges and fetching them.

ApplyMap (with Mapping Load) acts like 'Lookup' in excel.

More info on both :

http://community.qlik.com/thread/93674 : IntervalMatch

http://community.qlik.com/thread/98764 : ApplyMap

Hope it helps!

Cheers !