topic Re: How to compare specific value from csv using tmap in Talend Studio

How to compare specific value from csv using tmap

Anonymous — Sat, 16 Nov 2024 07:20:02 GMT

I have two delimited files in which i need to compare the last value and display as pass or fail, for which I am using tMap.

File-1:

123-D1-abc-rtey121-a1b1-0.00

141-B1-fhf--fb32-utoot21b-b2b2-1.213

456575-C1-21-ytuueoro-ghfyt-43-2.31

4567-B1-abc-grth-a1b1-0.17

File-2:

123-D1-abc-rtey121-a1b1-1.00

141-B1-fhf--fb32-utoot21b-b2b2-1.213

456575-C1-21-ytuueoro-ghfyt-43-4.31

4567-B1-abc-grth-a1b1-0.17

Below is my tMap design:

tMap3:

I am able to run the job, but output is generating 16 rows (4*4),I need only 4 rows in the output as below

I need output as below..

D1 | 0.00 | 1.00 | Fail

B1 | 1.213 | 1.213 | Pass

C1 | 2.31 | 4.31 | Fail

B1 | 0.17 | 0.17 | Pass

Note: I am able to retrieve the values using String Handling functions.

Not sure where i am doing wrong in the tMap models. Please suggest.

Re: How to compare specific value from csv using tmap

Anonymous — Fri, 09 Nov 2018 07:04:07 GMT

Hi,

In the tmap joins (left side above inner join), could you please use Uniuq match instead of All matches?

If the answer has helped you to resolve your problem, could you please mark the topic as closed? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: How to compare specific value from csv using tmap

Anonymous — Fri, 09 Nov 2018 10:04:34 GMT

@nthampi

This is not working, All the values of File-1 are compared with last value of File-2

0.00 | 0.17 | Fail
1.213 | 0.17 | Fail
2.31 | 0.17 | Fail
0.17 | 0.17 | Pass

Re: How to compare specific value from csv using tmap

Anonymous — Fri, 09 Nov 2018 10:29:59 GMT

Hi,

Could you please try to match the data with all columns in both files (except last column)? For example, use all columns like below for match.

123-D1-abc-rtey121-a1b1

This will avoid unnecessary matches between rows. You can even generate the row number sequence for each file before matching if you are sure that records will exist in both files at same line number.

Warm Regards,

Nikhil Thampi