Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to group while mapping load

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

Tags (1)
5 Replies
Luminary
Luminary

Re: How to group while mapping load

Hi Pavan,

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

Cheers,

DV

www.QlikShare.com

MVP
MVP

Re: How to group while mapping load

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

MVP & Luminary
MVP & Luminary

Re: How to group while mapping load

Hi Pavan,

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

Regards,

Jagan.

Not applicable

Re: How to group while mapping load

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

MVP & Luminary
MVP & Luminary

Re: How to group while mapping load

Hi Pavan,

It is not possible you have to specify individually.

Regards,

Jagan.