How to group while mapping load

[#1]

Hi Friends

I have trying mapping load

FLAG_MAP:

Mapping LOAD * INLINE

[

COND, FLAG

01-08, Amount1

01-09, Amount1

02-01, Amount1

09-08, Amount2

];

Is there any simple way I can group first three rows as Amount1 instead of writing three times.

Thanks

Pavan

[IAMDV]

Hi Pavan,

Create a temp table and then use resident load to create the grouped mapping table.

Cheers,

DV

www.QlikShare.com

[tresesco]

No. If you use mapping load, you have to do that extra effort.

[jagan]

Hi Pavan,

If you are using mapping load you have specify value for each row (Key-Value pair).

Regards,

Jagan.

[#5]

Hi Jagan,

I need to map multiple condition to one column, Can I have multiple values to one key while using apply map funtion??

COND, FLAG

01-01, Premiums _Amount

01-02, Premiums _Amount

02-01, Premiums _Amount

02-02, Premiums _Amount

01-03, Premiums _Amount

01-04, Premiums _Amount

01-05, Premiums _Amount

01-07, Premiums _Amount

[jagan]

Hi Pavan,

It is not possible you have to specify individually.

Regards,

Jagan.