https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631319#M446482 <P>No, Just want to get the counts of users which have email/mob no in the excel file, that has a mapping with actual data.</P> Fri, 04 Oct 2019 03:23:46 GMT sujit_nath 2019-10-04T03:23:46Z https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631310#M446480 <P>There is a scenario – CID | email | mobile, Now a file is provided from 3rd party containing email and mobile in same column – “email mob” the rows will either contain mobile or email of customers. How do I know which customers have record in the base table? For one customer it may be possible that either email, or phone or both email and mobile are mentioned.</P> Sat, 16 Nov 2024 02:18:40 GMT https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631310#M446480 sujit_nath 2024-11-16T02:18:40Z https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631317#M446481 <P>What is the end goal here?</P><P>If the columns in base data are empty, then update with 3rd party data?</P> Fri, 04 Oct 2019 02:55:21 GMT https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631317#M446481 Arthur_Fong 2019-10-04T02:55:21Z https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631319#M446482 <P>No, Just want to get the counts of users which have email/mob no in the excel file, that has a mapping with actual data.</P> Fri, 04 Oct 2019 03:23:46 GMT https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631319#M446482 sujit_nath 2019-10-04T03:23:46Z https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631320#M446483 <P>Can you provide a sample base data and a sample 3rd party data you mentioned above?</P> Fri, 04 Oct 2019 03:32:59 GMT https://community.qlik.com/t5/QlikView/Get-counts-of-matching-users/m-p/1631320#M446483 Arthur_Fong 2019-10-04T03:32:59Z