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.
Below is my tMap design:
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.
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 :-)
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
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.
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.