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,

Please tell me how to iterate data using LAE 4.6 Node
Example
calling_Number
9800000001
9800000002
9800000003
9800000004
9800000005

Output
To check these numbers are in sequence and with uniform interval

Please tell me how to achieve this using iteration(as in using Loop)

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

Originally posted by: ltolleson

You can use the Interval Inspection node in the Lavastorm Analytic Library (LAL). If you don't have this library installed you can download it from the link below.

http://www.lavastorm.com/resources/s...lytic-library/

If you are using an Enterprise server you will need to download the Linux/Solaris install as well.

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,

I have tried the Interval Inspector but it is not yielding the desired result.
can you please just give me sound example about how to use it.

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,

Please provide an detail example of the Interval Inspection Node and how it can be used to check the interval between multiple row of data is same or different for different data types like Integer, String, Date etc.

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

Originally posted by: Tim Meagher

Hey,

I've an attached a graph which shows how to do this for long, date, and time values.
Similar logic could be used for datetime as well.

The Interval Inspection node requires that the SequenceExpr evaluate to a number (long, int, double).
Therefore, if you are comparing string data, you would first need to be able to create a numeric representation of that string which can be then used for the comparison.
In the case of the "CallingNumber" example you had above this will simply involve converting the string to a long value.

For dates, and times, you can construct your SequenceExpr based on the type of interval you are looking for.
In the examples I've attached, I am checking that all of the time fields are 1 second apart.
In the date case, I'm checking that they are each 1 day apart.

Hope this helps.

Tim.
Attachments:
IntervalInspection.brg

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

Originally posted by: techm_aritra

Hi Tim,
let me give u an example. Please check the data below
Calling_Number
9800000000
9800000010
9800000030
9800000070
9800000130

This data may not be have a fixed interval but these are part of a series now if I want to find the interval between all these data and mapped the similarity of the interval how can I do it.

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

Originally posted by: ltolleson

Assuming that your Calling_Number is a string type you can use the code below in a Filter node to find the difference between Calling_Number in the rows. You could then use an Agg node to count the number of times a specific CallingNumDiff value occurs in your data.


CallingNum = 'Calling_Number'.long()

if firstExec then
tempCallingNum = CallingNum

CallingNumDiff = (tempCallingNum - CallingNum).abs()

emit *, CallingNumDiff

tempCallingNum = CallingNum

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

Originally posted by: techm_aritra

I have used the below code to do the processing


fraudText = ""
intervalInspect = 0
tempIntervalInspect = 0
iter = 0

calledNumber='Called_Number'.long()
if firstExec then {
tempCalledNumber = calledNumber
} else {

while iter < totalCallCount {

intervalInspect = (tempCalledNumber - calledNumber).abs()
if tempIntervalInspect == intervalInspect then
iter = iter + 1
tempIntervalInspect = intervalInspect
tempCalledNumber = calledNumber

}
#tempCalledNumber = calledNumber
}

if iter >= 100 then {
fraudText ="Fraud has been commited for"
} else {
fraudText ="Fraud has not been commited for"
}

emit fraudText as "Comment", Calling_Number as "Calling Number"
where iter >= 100