Forum Discussion
Creating table with categories from 2 columns in 1 column
Hi people, I am creating a content performance report. My company posts content on LinkedIn, and assigns a domain to each article. However, one article can have multiple domains. In the datafile ...
Unpivoting as hashtag_pete suggests is a good idea but it does bring complications. One approach would be to do this unpivot in a separate table so that you have a Domains table like this:
and an Articles table like this:
And have them related like this:
What's the logic behind 'Living' getting 1 in the Number Of articles?
My mistake, there is no logic. I have been staring at these things for way too long 😂 Let me adjust my original post! Thanks for letting me know.
I thought this is the count of how many times was this category addressed?
In your example, Living exists once, Work twice and Care three times...
yes you are correct, I adjusted my mistake in my original post so you can disregard HotChilli's question 😊
