LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

Hello All:

Trying to match the data from table one to table two. Below is an example of where all three fields from table on match table two, but the x_ref node doesn't match the record. There are other times where the x-ref nod does pick them up as matches. I assume it has to do with the SUM_CHARGE field and Revenue Fields both of which are double format

RECEIVER_CUSTOMER.str().trim(),
CHARGE_CODE.trim(),
SUM_CHARGE

prop:RightInputKey=<<EOX
BAN.trim(),
FEATURE_CD.trim(),
Revenue

table 1

SUM_CHARGE RECEIVER_CUSTOMER CHARGE_CODE
41.8 10000 HSIA

table 2

RECEIVER_CUSTOMER CHARGE_CODE Revenue
1000 HSIA 41.8

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

It is an in-elegant solution, but convert both to strings.
just add str() to the SUM_CHARGE and REVENUE fields.