can we have only auto-fixed rows in the output table

[Anonymous]

I am running a Job on which I have put some auto-fix condition o a column. I am getting the correct result, but in the output table can we have only those records on which the 'fix' was applied? Currently it is showing all the records. Because we may have thousands of records, so showing only those records where fix was applied would be very useful.

[TRF]

Hi,

The simple way is to duplicate the flow (tReplicate) before the tMap to identify the rows corresponding with the replacement rule (using a tFilter for example).

Then on the next subjob, you can join the content of "tem_tabledata" with these candidates using a join in a tMap.

You will get what you expect.

Hop this helps.

[Anonymous]

Thanks for the reply but not very clear. Can you help me with a sample job?

[Anonymous]

Hi ,

You have to check input data name having null value are not ?

Count the not null values records in Input .

If the Rejected records in output you have to check the rejected flow in database output component.

Thanks,

Madhu. 

[Anonymous]

No, that's not what I am seeking. My concern is that only those records on which auto-fix has been applied should move to my output table. Null checks I can apply.

[cterenzi]

Add a second tMap that uses an output filter comparing the original name to the (potentially) modified name.

[TRF]

If you want get only the fixed row to the target database, add a tFilter before the tMap with the appropriate condition to select only the rows that will be fixed.

Base on your 1st example, rows which contain a digit are selected, others are not.

[Anonymous]

Hi ,

Use this function row1.Name != null && row1.Name.matches(".*[0-9].*")  in tmap filter expression.

Please check below screen shots for reference.

capture1.png
capture2.PNG
capture3.png

[Anonymous]

Ok Thanks for the reply.

Another scenario is can I have both the values i.e. the old value and the fixed value as two rows in the table without defining any new column for comparison purposes. Like currently I define a new column in the table to show the'fixed value'. This is to help my client to see both the records one after other and take a decision to approve the change or not. Please see the screenshots below.

[Anonymous]

Any replies on this please?