LAE

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

Originally posted by: techm_aritra

Hi,

I have tried to join two different set of data different set of file with same datatype(Unicode).

i have used the following brain script in the "JoinExpr" input field
script: 2:hotlist == left(1:Called_Number,strlen(2:hotlist))

please let me know how that can be resolved.

i have also send a error report to DesktopSupport@lavastorm.com

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

Originally posted by: ltolleson

The JoinExpr parameter is deprecated and should not be used. If you are trying to do an inner Join then use the "Join Inner" node and put your criteria in the "where" of the "emit" statement.

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

Originally posted by: techm_aritra

thanks Larry, will try this and let u know

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

Originally posted by: techm_aritra

Hi Larry,

Join Inner worked but it is unable to give the wanted result. I want a partial match between two unicode data, but it is not at all doing so. It is giving a simple match operation.
Please provide a solution.

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

Originally posted by: ltolleson

If you set both the left and right keys to some constant value like true or 1 then it causes the node to match all left records to all right records. Then in the emit statement you can implement your where clause 2:hotlist == left(1:Called_Number,strlen(2:hotlist)) and it should return the correct matches.

I would caution you using this method though if you have large amounts of data for both inputs because the node could run for an extended period of time.

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

Originally posted by: techm_aritra

Hi Larry,

There is one record in �hotlist� is �9831� which is partially matching with few of the data of the other file. I have tried to find those record which will partially matched with �9831�. Please let me know example of the such kind of possibility.

like
hotlist Data:
HotList(unicode)
9831
9433949179

data need to matched with
CDR:
phoneNo(unicode)
9831631317
9831156110
9830138700
9433949179

Desired result after matching
RESULT:
result(unicode)
9831631317
9831156110
9433949179

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

Originally posted by: ltolleson

See the attached graph. This should give you the results you are after.

Thanks,
Larry
Attachments:
HotListResults.brg