topic Applymap with wildcard in App Development

Applymap with wildcard

43918084 — Mon, 20 Dec 2021 21:08:46 GMT

I have the above mapping table that I want to map against a leger book based on field GRCA key and Field GL Account.

Some of the mapping has specific GRCA account and GL account. For the last GRCA ,"PK14910", it can map with any GL account.

May I know how I can use Applymap to map? Many thanks.

forte — Fri, 06 Nov 2020 08:52:33 GMT

When you're talking about mapping you should take into account its definition. A mapping table in Qlik links a single value with a single key.

If you need to link with a cardinality different of 1 , you may consider using join.

Hope it helps

Regards

43918084 — Fri, 06 Nov 2020 09:04:48 GMT

Thanks a lot. If I use join, may I know if I have to create 2 tables. One with GRCA and GL account and another with GRCA only?

marcus_sommer — Fri, 06 Nov 2020 09:10:51 GMT

You need only to query if GRCA is PK14910 to replace the GL value, maybe like:

applymap('map', GRCA & '|' & if(GRCA = 'PK14910', '<ANY>', GL), 'non matching') as Group

whereby you also add <ANY> as value for PK14910 within the mapping-table.

- Marcus

43918084 — Fri, 06 Nov 2020 09:16:45 GMT

Thanks a lot, Mr Sommer. So <ANY> means to map any GL Account that is GRCA PK14910?

43918084 — Fri, 06 Nov 2020 09:34:25 GMT

Thanks a lot. It works. May I also inquire, If I have many GRCA like the PK14910, does it mean I have to type the same code one by one?