topic Re: comparing string to a list of strings in Talend Studio

comparing string to a list of strings

Anonymous — Wed, 28 Nov 2018 15:36:12 GMT

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

Re: comparing string to a list of strings

Anonymous — Wed, 28 Nov 2018 16:53:47 GMT

Hello,

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

Re: comparing string to a list of strings

Anonymous — Wed, 28 Nov 2018 17:50:35 GMT

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

Re: comparing string to a list of strings

Anonymous — Thu, 29 Nov 2018 05:28:07 GMT

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

Re: comparing string to a list of strings

Anonymous — Thu, 29 Nov 2018 08:46:37 GMT

tNormalize Component should help.

Pierre.