Wildmatch in set analysis to search values from an entire column

[Ashish_1102]

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.

[Brett_Bleess]

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

[Carlos_Reyes]

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.