How to compare specific value from csv using tmap

Highlighted
Six Stars

How to compare specific value from csv using tmap

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: 

image.png

 

 

tMap3: 

image.png

 

 

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. 

 

Employee

Re: How to compare specific value from csv using tmap

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

Six Stars

Re: How to compare specific value from csv using tmap

@nikhilthampi

 

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

 

 

Employee

Re: How to compare specific value from csv using tmap

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