Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm building a dashboard of a partner network. I am working with the second layer of partners (partner's partners) and only want to show the count of the partners that match people we currently partner with. I currently have a field with all of the partner's partners (with a huge long tail) but I want to only display the count of partner's partners who match my companies partner list. How can I get it to count/display the partner's that match with a list of my companies existing partners? Thanks!
Hi,
Create a Mapping Table from your companies partner list into the field with all the partners and use that to create a 0 or 1 flag.
Then you can sum that field.
You can read about mapping here:
or provide some data like Deepak mentioned above and it should be a quick solution.
Best,
Ali A
can you please provide the sample app and the output you are expecting
Hi,
Create a Mapping Table from your companies partner list into the field with all the partners and use that to create a 0 or 1 flag.
Then you can sum that field.
You can read about mapping here:
or provide some data like Deepak mentioned above and it should be a quick solution.
Best,
Ali A
Dear Matthew,
Please try as below
YOURCompanyData:
Load
.
Your companies partner . as partner
.
.
.
From YOURtable;
partnerspartner:
Load
partner's partner as partner
.
.
.
From
partner's partner
Where EXISTS(partner, partner's partner)
then it matches.
Regards,
Mithilesh
Thank you all very much for your replys, I ended up resolving my issue using the mapping