Hello.
When creating Form, select FormName MLB News.
The category of MLB News is Baseball and MLB.
In the Member Table, John and Nick are the people whose Interests are Baseball or MLB.
Iโd like to bring John and Nickโs email list, how can I do the formula?
I tried this, but I couldnโt get the result I wanted.
select(Member[Email], in(select(Form[Category], [FormName] = โMLB Newsโ), split([Interests], " , ")))
Please help me.
Thank you.
Solved! Go to Solution.
Sorry, typo. Was supposed to say โsome sortโฆโ.
It is good that both are EnumLists, so you wonโt need to use SPLIT(). The comparison basically just needs to be โis there any interest in commonโ, correct?
If so, how about we just use ISNOTBLANK() with INTERSECT()
Try this:
SELECT(
Member[Email] ,
ISNOTBLANK( INTERSECT( [Interests] , [_THISROW].[Category] ) )
)
What types of columns are [Category] and [Interests]? EnumLists, orโฆ?
Your expression will take a form more like this:
SELECT(
Member[Email] ,
#some-sort-of-comparison-between# [Interests] #and# [_THISROW].[Category]
)
Hello, Marc_Dillon.
[Category] and [Interests] columns are EnumLists.
I donโt understand the #sort-sort-of-comparison-between# part well.
Please explain.
Sorry, typo. Was supposed to say โsome sortโฆโ.
It is good that both are EnumLists, so you wonโt need to use SPLIT(). The comparison basically just needs to be โis there any interest in commonโ, correct?
If so, how about we just use ISNOTBLANK() with INTERSECT()
Try this:
SELECT(
Member[Email] ,
ISNOTBLANK( INTERSECT( [Interests] , [_THISROW].[Category] ) )
)
Wow!
Itโs been solved in a cool way to go.
SELECT(
Member[Email],
ISNOTBLANK(INTERSECT([Interests], SELECT(Form[Category], [ID] = [_THISROW].[Form])))
)
Thank you so much, Marc_Dillon.
Why are you using:
instead of just:
?
The Interests column is in the Member Table, and the Category column is in the Form Table.
"[_THISROW].[Category] "Unable find to column โCategoryโ error occurs if you enter only this.
And when I looked again, the Category Column attribute was Enum, so when I changed it to Enum List, there was an error and I corrected it as follows.
SELECT(
Member[Email],
ISNOTBLANK(INTERSECT([Interests], SPLIT(SELECT(Form[Category], [ID] = [_THISROW].[Form]), ","))
)
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |