How to use applymap function instant of left join(because of left function is much expensive)

[#1]

HI

How to use applymap function instant of left join.

because of left function is much expensive.

Regards

Ashish

[sparur]

Hello.

ApplyMap is useful if you need join 1 field or you should create some maps (one map for each field) How it use:

1) you should create a map table:

Map1:

MAPPING LOAD *

INLINE [

F1, F2

A, 1

B, 2

C, 3];

2) for table where you want to see field F2 you should use applymap() function:

table:

LOAD field1,

Applymap('Map1', field1) as mappedfield

From....

where field1 has values: A, B, C

After this you get table:

field1, mappedfield

A, 1

B, 2

C, 3

Such effect you can achieve by using Left join:

table:

LOAD field1 FROM...

LEFT JOIN

LOAD F1 as field1, f2 as joinedfield

INLINE [

F1, F2

A, 1

B, 2

C, 3];