Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

5 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi Pavan,

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

Cheers,

DV

www.QlikShare.com

tresesco
MVP
MVP

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

jagan
Luminary Alumni
Luminary Alumni

Hi Pavan,

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

Regards,

Jagan.

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi Pavan,

It is not possible you have to specify individually.

Regards,

Jagan.