Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Pavan,
Create a temp table and then use resident load to create the grouped mapping table.
Cheers,
DV
www.QlikShare.com
No. If you use mapping load, you have to do that extra effort.
Hi Pavan,
If you are using mapping load you have specify value for each row (Key-Value pair).
Regards,
Jagan.
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
Hi Pavan,
It is not possible you have to specify individually.
Regards,
Jagan.