comparing string to a list of strings

[Anonymous]

Hello 

I'm sorry if this topic is  already published.but I can' t find a better way to resolve my problem.

I have a tmap  below as a screenshot.

I want to return for every title_song  a musical genre using tag_name . in tags you can find genres or subsubgenres . so I need to see if genre attribute contains tag_name  as a substring so return that genre and the title_song corresponding to it else return "others".

How to do this with talend ?

Thank you 

[Anonymous]

Hello,

You can try to make a left outer join between the tag name and the genre field.

[Anonymous]

I can' t do that . because you can find for exemple "classic rock" as a tag_name value but in genre attribute you can find  values as "rock" so in this case I want to return just rock 

[Anonymous]

Hi,

     You will have to align the genre and tags correctly so that your left outer join will work in proper way. So if a song has multiple tags, why don't you break it to granular level and then go for the matching?

Warm Regards,

Nikhil Thampi

[Anonymous]

tNormalize Component should help.

Pierre.