topic Re: How to use min function along with applymap in App Development

How to use min function along with applymap

abc_18 — Fri, 08 Mar 2019 11:26:51 GMT

Hi,

I am trying to use min() function along with applymap, but I am getting invaild expression error beacuse of the use min function.

Below is my expression:-

[market_tmp]:
LOAD
ABC_Key ,
DEF_Key
FROM [$(vQVDLib)map_standard.qvd] (qvd);

[market]:
Mapping Load ABC_Key
,ApplyMap('MAP_skey_market',min([DEF_Key]),Null()) as skey_market
Resident [market_tmp];

drop table [market_tmp];

Can someone please sugegst, where am I making mistake?

Re: How to use min function along with applymap

santhiqlik — Fri, 08 Mar 2019 11:38:20 GMT

Hi,

You need to use Group by in your mapping load.
market:
Mapping Load ABC_Key
,ApplyMap('MAP_skey_market',min([DEF_Key]),Null()) as skey_market
Resident [market_tmp] group by ABC_Key;

Re: How to use min function along with applymap

sunny_talwar — Fri, 08 Mar 2019 12:10:34 GMT

You are using ApplyMap in your mapping table? You have another mapping table called MAP_skey_market?... not that this is wrong, but just want to make sure you are aware of this and are doing it right.