Let’s say I have a list of articles, each article has comma delimited list of keywords. I want to show “Related articles” under the article I am viewing, based on at least one identical keyword. What’s the best strategy for that without having to create categories?
I “think” what you could do is use the split text field to separate out the values. Then create a relationship to those values. This should bring in other articles with those same values. Then just place a component with the relationship under the article content.
You would create a relation column, it should be pulled from your split text column and then again related to the same split text column on the relation.
Then any articles that have any of the same keywords would populate in the relation.
Make sure to select the match multiple option as well.
Something looks off with your relation column. I just noticed that it looks like it’s populating values within the related keywords column that shouldnt exist.
Make sure that your relation is from the same tab and to the keyword split text column. You are basically relating rows in the same tab.
In your screen shot, you should only have the first 3 rows populated (in the rel-keywords column) if the relation is setup correctly.
It looks fine to me, everything is showing correctly in the split keyword column, what I was missing was a lookup column. Now it’s showing me the articles.
The split keyword values are missing (from row 4 down) but the related keywords are still populating. Technically this shouldn’t happen (if you are using the real keywords as the relation) because there are no keyword values to pull in the relation.
So that leads me to believe that the relation itself might be pulling from another area. It should only pull from keywords split text, same tab.