How to compare specific value from csv using tmap

[Anonymous]

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. 

[Anonymous]

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

[Anonymous]

@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

[Anonymous]

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