Comparing Values in Join Component

I have a requirement where ino and in1 will have amount column. The join key is amount.
Foe example:
(1)
in0 - 10
in1 - 10

This would come to output as both the amounts are matched.
(2)
in0 - 10
in1 - 15

these 2 records would go to unused0 and unused1 as both the amounts are not matched.

(3)
in0 - 10
in1 - 10.5

These 2 records would go to unused0 and unused1 as both the amounts are not matched.

The requirement is, if the difference between in0 and in1 is <=1, then the amount should go to output but not to unused ports.
From the example (3) 10.5 - 10 = 0.5 which i less than 1, so these record should go to output but not to unused port.

Try rounding up the input values from decimal to an integer ie. from 10.5 to 10 using floor function and then join. So now you'll be able to get that in output. If its, 11.1 and 10 it will be rounded to 11 and 10 hence you will get that in unused as required.

Benny,
If its 10.5 and 10, I can floor and make it as 10, 10..so that the records does not goto unused port...but when it is 11.1 and 10, I should not float bcs as the difference is >1, exact value should be going to unused ports.

@Srinivas, the example you have taken seems a bit misleading. So it is important to understand your data before suggesting which component is helpful.

The example which you have chosen, 10 will never go into the unused0 because it got a match with the in1 where 10 is present.

Foe example:
(1)
in0 - 10
in1 - 10

This would come to output as both the amounts are matched.
(2)
in0 - 10
in1 - 15

These 2 records would go to unused0 and unused1 as both the amounts are not matched.

(3)
in0 - 10
in1 - 10.5

These 2 records would go to unused0 and unused1 as both the amounts are not matched.

It is also important to understand whether both the ports will have equal number of records and it is ordered in such a way so that the comparison can be done? If so, then Fuse component is helpful. Else it is not.

Would it be possible for you to explain with the dataset from in0 and in1 like

(1) Should go to output as both are matching
(2) Should go to unused ports as both the amounts are different and also the difference is >1 or <-1
(3) Should go to output as both amounts are different but difference is 0.5 which is <1

Please note that Join is for matching not for comparing.
But I think your requirement is for comparing if the difference is more than 1.

If you use Join then all the 3 record of in0 will get a match with the record of value 10 in in1, as mentioned by Saravanan. (according to your sample provided)

This can be done in Fuse but make sure your records are in order and also which record is expected to go in the out when the condition is satisfied.
In case if the number of records are not in sync in the input ports then follow one of the 2 methods described below -

1) If you dont want to process the extra records which will cause the sync issue -