Avatar

Stony Smith

  • Total activity 60
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 26

Activity overview

Latest activity by Stony Smith
  • Avatar

    Stony Smith commented,

    In a transform node: b="N"if A.strFind("t") and not A.strFind("r") then b="Y"emit Aemit B=b

  • Avatar

    Stony Smith commented,

    Dataverse has pow() and log()  you can compute the exp() and ln() with two simple formulas. e=2.718281828459045   #add more digits as necessary for acuracyln(x) = log(x) / log(e) exp(x) = pow(e,x) ...

  • Avatar

    Stony Smith commented,

    Which node are you using to do the query? DbQuery doesn't support variables.  You'd have to use DbExecute.   query="SELECT * FROM TESTTABLE WHERE Test = :?"sqlSelect(1,query,myField) in this case, ...

  • Avatar

    Stony Smith commented,

    Here's a trick for you: If you simply want to review the records 1000-1999, then add a HEAD node and configure it for 2000 records, and send that output to a TAIL node set for 1000.   That will giv...

  • Avatar

    Stony Smith commented,

    Use the Data Analyzer node to look at the data.  On the 2nd pin of the Data Analyzer, on the far right, are lines of code that can be used to manipulate the data. Copy that code into a Transform no...

  • Avatar

    Stony Smith commented,

    The DataReader is primarily for use with another Lavastorm product called the Lavastorm Data Reader (LDR) - it was designed mainly to handle high-volume CallDetailRecord files by a telephony operat...

  • Avatar

    Stony Smith commented,

    It may not be the "best" solution, but what I had to do for such a file was read it in with the Delmited_Input node, use a filter to remove those first 3 records, write it back out with the Delimit...

  • Avatar

    Stony Smith commented,

    The DataAnalyzer node is reporting the 'backoffice" data type for the field.. It makes sense not to confuse the issue.  In the background, there is a (slight) difference between integer and bint, s...

  • Avatar

    Stony Smith commented,

    Nothing to correct. bint is "binary integer".. meaning that the data is stored in an internal format which is quicker to process. Where are you seeing the bint? in the data viewer, or by looking in...

  • Avatar

    Stony Smith commented,

    With windows and dlls.. i'm not certain whether  you should set LD_LIBRARY_PATH or simply add the folder above to the PATH. Either way, I would select only one of the two folders at a time and yes,...