Subfield for Movie Genres

[Jojo17]

Hi there, 

my data looks as follows:

Genres:
Animation | Children | Comedy 
Fantasy 
Action | Adventure | Romance 
Drama | Thriller 

(and the list goes on, with each movie having various numbers of genres) 

Am looking to use the sub field function to do an assessment on the Genres, would need some help here, thank you! 🙂 

 

[Anil_Babu_Samineni]

What you want from that data? May be

Subfield(FieldName, '|') as Output

[Jojo17]

One movie is tagged to a few genres and I would like to have a chart which shows the various genres and the number of movies per genre. 

[Anil_Babu_Samineni]

Your data structure not understand to me. Can you create proper data and expected result 

[uacg0009 · Accepted solution]

Hi Jodi,
I assume that you have "movie" and "genre" in your table.
And firstly you need to use subfield() in your srcipt,like:
load movie,
subfield(genre,'|') as genre
resident yourtable;
Then in the front-end, you can create a straight table:
dimension: genre
expression: count(distinct movie)
please try.
Aiolos Zhao

[Jojo17]

My data file looks as follows:

I would like to create a chart which shows which genre is most popular. 

I tried the following: 

LOAD MovieID,
            Title,
            Genres

           Subfield(Genres, '|') as Genres

But it did not return a result and was an error. 

[Anil_Babu_Samineni · Accepted solution]

Error - Because, You are using same field with in the Single Load. Perhaps this?

LOAD MovieID,
            Title,
            Subfield(Genres, '|') as Genres

From Sample;

[Jojo17]

I see, thanks! Managed to get it to work now 🙂