Clarification on some values!

[nevilledhamsiri]

Dear All,

I have two tables to compare & analyze any differences!. The script I have given carries said two tables. I have two factors to be clarified.

1: When ever a balance not appearing in resident table (Refund_New) though a balance there in the 2nd table (BR_SCHE) that is not reflected in the table.(check EH0017C0002887, Only when I add some .002 value difference was reflected otherwise that record is not appeared as difference of Rs 3000/=.

2: I need to sort out the records which are not in order. (Records which are not order refers to difference of the values either more than 10 or more than -10. Hope one may modify my IF statement given in the script to accomodate this level.

REFUND_NEW:

LOAD BR_CODE, TRN_DATE, CRE_NUMBER, DES, POL_NUMBER, F6, BALAMT

FROM (biff, embedded labels, table is Sheet1$);

BR_SCHE:

LOAD BE_CODE, Date, CR_NUMBER, Particulars, F5, Contribution, Settlements, Balance

FROM (ooxml, embedded labels, table is Sheet1);

LEFT JOIN (REFUND_NEW)

LOAD

CR_NUMBER AS CRE_NUMBER,

Balance

RESIDENT BR_SCHE;

FINALTABLE:

LOAD

*,IF(BALAMT-Balance<10,'OK','NO')AS ORDER

RESIDENT REFUND_NEW;

DROP TABLES

REFUND_NEW,BR_SCHE;

[nevilledhamsiri]

Please look in to this!

Thanks

Neville

[nevilledhamsiri]

please see in to this

Neville