topic How to group while mapping load in QlikView

How to group while mapping load

Mon, 15 Sep 2014 08:13:25 GMT

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

Re: How to group while mapping load

IAMDV — Mon, 15 Sep 2014 08:19:59 GMT

Hi Pavan,

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

Cheers,

www.QlikShare.com

Re: How to group while mapping load

tresB — Mon, 15 Sep 2014 08:20:19 GMT

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

Re: How to group while mapping load

jagan — Mon, 15 Sep 2014 08:33:23 GMT

Hi Pavan,

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

Regards,

Jagan.

Re: How to group while mapping load

Mon, 15 Sep 2014 08:43:42 GMT

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

Re: How to group while mapping load

jagan — Mon, 15 Sep 2014 08:49:00 GMT

Hi Pavan,

It is not possible you have to specify individually.

Regards,

Jagan.