How to use min function along with applymap

[abc_18]

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?

[santhiqlik]

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;

[sunny_talwar]

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.