topic Re: Finding keywords in a tabel in Talend Studio

Finding keywords in a tabel

jolio007 — Sat, 16 Nov 2024 06:31:37 GMT

Hello,

I'm new working with Talend so bear with me if I'm asking something ridiculous.
I have a 2 Excel Files. One with all the data and the other that has only one column. In the one with one column, I have key words. The goal is to look into the excel with all the data if a row contain the key words then if it does output a "Yes" in one column.
I have used a tJava to extract the keywords and I was told I could use a tMap but I'm not sure what the configuration would be .

Re: Finding keywords in a tabel

Anonymous — Thu, 21 Feb 2019 17:10:20 GMT

Hi,

Could you please share a sample file for both input and Keyword so that we will get some idea about your use case?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Finding keywords in a tabel

jolio007 — Thu, 21 Feb 2019 19:36:07 GMT

Re: Finding keywords in a tabel

Anonymous — Fri, 22 Feb 2019 05:21:05 GMT

Hi,

Please refer the screen shots below for the flow.

The first job will be used to find the matching conditions. For all the tfileInputDelimited components, select Trim columns option (advanced section) and use Pipe as the column delimiter.

In the first tMap, you will do a all row match as shown in diagram below.

The function to be used in output filter condition is as shown below.

row1.Label.toLowerCase().contains(row2.colour.toLowerCase() )

The output will be stored to csv file and the basic and advanced conditions are as shown below.

In the second subjob, you will pick only those records which are not present in previous file. The main flow will be the input file and the lookup flow will be the file generated in the first subjob.

Hope I answered your query 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Finding keywords in a tabel

manodwhb — Fri, 22 Feb 2019 05:25:44 GMT

@jolio007 ,you need to do the inner join with tMap or tjoin to match the record to get from single column file.

find the below links will help you to do inner join.

https://help.talend.com/reader/0DkFceSqOPXOhdoAY6uLQA/PXagRwiqRo5ZV0D3Ab60Mw

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/7VFow3bHpC71W~iGA3oYnA

Re: Finding keywords in a tabel

jolio007 — Mon, 25 Feb 2019 16:28:40 GMT

the lookup flow will be the file generated in the first subjob.

When I try to use the file generated in the subjob, I get an error - the file specified cannot be found

Re: Finding keywords in a tabel

Anonymous — Mon, 25 Feb 2019 17:44:32 GMT

@jolio007

Could you please share the screen shots of your jobs and individual component screen shots like in my post above?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Finding keywords in a tabel

jolio007 — Tue, 26 Feb 2019 08:53:52 GMT

here's the overal picture.
tFileInputExcel_1 is the input of the tFileOutputExcel_1.
With the tMap_7, I want to get the items that were rejected by the tMap_2. But it gives me the same thing as the tFileOutputDelimited_1
here you can see my setting in the tMap_7.

Re: Finding keywords in a tabel

jolio007 — Tue, 26 Feb 2019 09:46:15 GMT

I found the solution. All I needed to do was set the "Catch lookup inner join reject" as true

Re: Finding keywords in a tabel

Anonymous — Tue, 26 Feb 2019 10:27:08 GMT

@jolio007

Very good. It is always a happy moment when you find the solution yourself 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂