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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch