Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community members
i've a requirement. Any help would be hugely appreciated.
I've a data table like this -
PID | PNAME | Title | Headline | Published Date |
1 | ABC | ABC | xyz | 1/1/2019 |
1 | ABC | ABC1 | xyz1 | 2/1/2019 |
1 | ABC | DEF | ABc2 | 3/1/2019 |
2 | ghi | aBC | uvw | 4/1/2019 |
3 | jkl | DEF1 | ABc | 5/1/2019 |
In UI i've a staright table where i've to construct two expressions like this -
PID | PNAME | # by name match | #by title/headline match |
1 | ABC | 3 | 5 |
#by name match is a simple one where i just have to count the number of times ABC was published.
#by title/headline match is the trickier one. here i have to search that PNAme in the whole title and headline columns, wherever i find a wildmatch (e.g; ABC1) or a mixmatch (e.g; ABc) or a mixture of both (like ABc2) or an exact match, i've to count those published dates only.
I've manually populated the desired results in the straight table above.
Could you please help me to construct the second expression.
Many thanks in advance.
If you can attach an example app, that may allow someone to better help you if you are still trying to figure things out on this one.
Regards,
Brett
Hi,
I'm not really sure you can accomplish this through Set Analysis... since you need to "forget" about the relationships between the string you want to search and the records it has associated... so, I'd go for a script solution. Review the enclosed app.