topic Re: Mapping load with multiple values in App Development

Mapping load with multiple values

stonecold111 — Wed, 22 Dec 2021 19:11:32 GMT

Hi qlikss,

I have mapping table with multiple values.

Mapping table:

Key. Mail

100. Sri@gmail.com

100. 999-6667-778

100. 6785-889-888

200. 998- 5466-766

200. John@gmail.com

Applyma p(table,key)

How can I get only mail IDs in applymap when multiple values are there in mapping table

Re: Mapping load with multiple values

stonecold111 — Wed, 24 Feb 2021 11:39:16 GMT

Mail is at different occurances . sometimes it's at first, sometims 2nd or 3rd position.

Re: Mapping load with multiple values

stonecold111 — Wed, 24 Feb 2021 11:48:11 GMT

@QFabian

Re: Mapping load with multiple values

Taoufiq_Zarra — Wed, 24 Feb 2021 11:53:07 GMT

@stonecold111 you can always use script like :

DataMap: load * inline [ Key,Mail 5,sdsdsdsd@ss 100,Sri@gmail.com 100,999-6667-778 100,6785-889-888 200,998- 5466-766 200,John@gmail.com ]; left join load Key,count(Mail) as counttmp resident DataMap group by Key; TmpMap: load Key,Mail resident DataMap where counttmp>1 and WildMatch(Mail,'*@*')>0; load Key,Mail resident DataMap where counttmp=1; drop table DataMap; Map1: mapping load * resident TmpMap; drop table TmpMap; Data: load Key1, applymap('Map1',Key1,'ND') as Mail inline [ Key1 100 200 5 ];

output:

Re: Mapping load with multiple values

stonecold111 — Wed, 24 Feb 2021 12:42:50 GMT

Just by taking resident load with where condition

As wildmatch(mail,*@*) loads only records that has @ ,then we can join or use applymap.

Do we really need all these count function etc..

Re: Mapping load with multiple values

Taoufiq_Zarra — Wed, 24 Feb 2021 12:57:47 GMT

if you you have alway one row with @ you don't need all these count

Re: Mapping load with multiple values

stonecold111 — Thu, 25 Feb 2021 12:21:51 GMT

Ok thanks